Need Help??

[paulwalker]

Hi Community,

I have Quarter dimension and Qty Measure.

i want calculate Quarter on Quarter growth in Sales..

Thanks in Advance.........

[swuehl]

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

[paulwalker]

Hi Swuehl,

PFA,

when i am click Quarter it's not showing data..

Please once check...

[swuehl]

The document failed to open on my system. Any security / section access applied?

And please try to reduce your data a little.

[paulwalker]

Hi ,

Please try it once..

[paulwalker]

Hi Swuehl,

Please Once you see correct or not..

[swuehl]

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.

[paulwalker]

Hi,

PFA

[swuehl · Accepted solution]

Maybe like this?

[paulwalker]

Exactly,

Thank you Swuehl.......