Totals Grouped By 3 Months

[PaulBrumby]

Hi All, 

I have been asked to report on Totals for

1st Jan - 30th April

1st May - 31st Aug

1st Sept - 31st Dec

I have a standard Sum Fact Sales linked to Dim Calendar, can anyone help?

Cheers

[serpiva64 · Accepted solution]

Hi, 

you can use Groups

otherwise you can create a calculated column

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[lukiz84]

Do you want 3 different measures or do you want one measure (total) which is grouped by your requirements? (this would need another dim table)