Moving annual bar chart

[ale_nilo84]

Hi!

I am trying to build a moving annual bar chart, but so far i can just display only the 4 months of the year 2016 and not the last 12 months . How can i do it to display the last 12 months?

Thanks in advance

[Anonymous · Accepted solution]

I realized this by using variables and a calculated dimension

=if ((RepDate>=vStartDate) and (RepDate<=vEndDate),date(RepDate,'MM/YY'))

I have a master calender, the user selects the start month

Start and end variable will be set depending of selected date

[ale_nilo84]

I Could do what was suggested to do. But in the last column it shows a invalid value . What do you think it could have happened?, please help me

[sunny_talwar]

Try suppressing the null dimension by checking 'Suppress When Value Is Null' for your dimension on the dimension tab.

[ale_nilo84]

Problem solved, thanks!!

[sunny_talwar]

Please mark Rudolf's response as the correct answer as I merely helped you get the final bit corrected. If you want you can mark my response as helpful, but truly it's Rudolf who deserves the points for correct response.

Thank you and regards,

Sunny

[Anonymous]

goto Dimension tab and seect your dimension

then mark "suppress when value is null"

goto tab presentation and mark "suppress zero values"

that should suppress the last bar marked with "-"