Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Try suppressing the null dimension by checking 'Suppress When Value Is Null' for your dimension on the dimension tab.
Problem solved, thanks!!
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
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 "-"