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.........
Maybe like this?
You can use chart inter record functions like above():
Create a straight table with dimension Quarter, then an expression
=sum(Qty)
and for the change
=sum(Qty)/above(sum(Qty))-1
Hi Swuehl,
PFA,
when i am click Quarter it's not showing data..
Please once check...
The document failed to open on my system. Any security / section access applied?
And please try to reduce your data a little.
Hi ,
Please try it once..
Hi Swuehl,
Please Once you see correct or not..
I have an idea, but this would require your Quarter being in chronological load order.
Attaching a modified load script that should do this. Please reload and re-upload.
Hi,
PFA
Maybe like this?
Exactly,
Thank you Swuehl.......