Make Total By Column same report

[Anonymous]

Hi Everyone

I'm tying to make a simple variance between some columns in a same report in Figures and in %

Here below i'm trying to do ACTP Vs. LE (Var+/- and %) and on the same table ACTP Vs. PLAN (Var+/- and %) and finally ACTP Vs. A-1(Var+/- and %)

will it be possible ?

Thanks

[Anonymous]

Thanks i didn't think of that .....

[tex628 · Accepted solution]

Hi @Anonymous , 

You will need to create all the calculations with measures instead. So something along the lines of 

ACTP = Calculate( Sum( Table[Column] ) , Table[Column] = "ACTP" )

LE = Calculate( Sum( Table[Column] ) , Table[Column] = "LE" )

ACTP/LE Variance = [ACTP] - [LE]

ACTP/LE Variance % = 
VAR Percent_ = DIVIDE( [ACTP] , [LE] , BLANK() )
Return
IF( Percent_ = BLANK() , BLANK() , Percent_ )

Then do the same for the rest of the calculations! 

Br, 
J