on 11-24-2014 3:49 PM
Is there a way to calculate the difference in the overall result column or a new column when using 1 measure (ie Gross Sales) that is shown with 2 separate members also in columns (ie. FY 2014 and 2013)? I am aware of the "Calculate totals as" option, but do not see a difference or variance that correspondes to what I am looking to do. Example below. Any suggestions?
Thanks!
Hi,
You could create the calculation in your query or use and excel function?
Regards
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.