Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivvl0
Creator III
Creator III

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

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

10021101090-20200110

month

3456

  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.

1 Solution

Accepted Solutions
yanivvl0
Creator III
Creator III
Author

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

View solution in original post

8 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Hi,

Please find the attachment.

Hope it helps you

Cheers!!

Jagan

tresesco
MVP
MVP

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
Creator III
Creator III
Author

GREAT help - perfect solution - thank u jagan!!

jagannalla
Partner - Specialist III
Partner - Specialist III

Can you mark as correct answer

yanivvl0
Creator III
Creator III
Author

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

jagannalla
Partner - Specialist III
Partner - Specialist III

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
Creator III
Creator III
Author

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

yanivvl0
Creator III
Creator III
Author

DONE