Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create a chart showing sales for a Prior Fiscal Quarter?
I know how it is done with a standard calendar but the scripting doesn't work when you apply it to a fiscal calendar. I can set up a variable that will calculate the previous quarter as well, however, when I select Quarter 1 it wants to try and display Quarter 0 instead of quarter 4 of the previous fiscal year.
Thanks,
Chris,
Can you try this.
May be you need to write a case logic to check if your previous quarter & current quarter are in same year, then consider previous quarter else return null() & in chart dimension properties suppress null.
Thanks
Brad.