How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

[yanivvl0]

hi every one ,

i am new in QV , and use to think SSAS Olap ,so i want to perform what i wrote in the head line :

to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

  for example if in the (table) chart there is months
dimension and sales measure - i need to see the difference ( as another measure )

between any month and the previus month - FOR ALL MONTHS , like :

	sales	diff prev sales	sales	diff prev sales	sales	diff prev sales	sales	diff prev sales
	100	2	110	10	90	-20	200	110
month	3		4		5		6

  as u see in apr the sales = 110 and the diff between mar =
110 - 100 = 10 , and so on for all .......

in ssas it is very simple and natural , here in QV  ,

i have tried to use set analysis but its solve the problem
for 1 month only ,

- can any one SAVE me ? Thanking you in anticipation.

[jagannalla]

Hi,

Please find the attachment.

Hope it helps you

Cheers!!

Jagan

[tresesco]

See this blog: Calculating rolling n-period totals, averages or other aggregations to understand how to refer a value not there in dimension scope using Aggr() and set analysis. To get specific help, try to post your sample app.

[yanivvl0]

GREAT help - perfect solution - thank u jagan!!

[jagannalla]

Can you mark as correct answer

[yanivvl0 · Accepted solution]

yes , sorry but how can i do it ? i'm new here ..

[jagannalla]

Select on proper answer post and choose correct answer.

For eg:

My post is correct one, so you can click on Correct answer.

But you had selected your post as correct, plz uncheck it and select on my correct post.

[yanivvl0]

thank u !! i have learn much from this link - much help.

[yanivvl0]

DONE