Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have Quarter dimension and Qty Measure.
i want calculate Quarter on Quarter growth in Sales..
Thanks in Advance.........
But small prob, I have Q1 data also..
but here it's not showing....
Once you take Qty in listbox,
Yes, you have data for Q1. And I also noticed, your data spans two years.
If you aggregate your data on Quarter basis across all available years, there is no preceding Quarter for the first quarter to calculate the percentage change (like in a list box, there is no Quarter above Q1).
If you want to consider the Quarter on a year basis, then you could include in the advanced aggregation dimension list and maybe average the change percentage across years.
Not sure if you understand what I am trying to say, maybe the attached updated version helps.