cancel
Showing results for 
Search instead for 
Did you mean: 

AO1.4 SP8:How to calculate difference for 1 measure 2 displayed members

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You could create the calculation in your query or use and excel function?

Regards

Michael