In Pivot table, How to fabs first and then sum

[Anonymous]

Hi,     I’m trying to get the final result as sum of total for the +ve and –ve values. Please help.sunindia‌

[sunny_talwar]

Try this:

If(Dimensionality() = 2, SUM([TOTAL EXPENSES]), Sum(Aggr(If(Sum([TOTAL EXPENSES]) > 0, Sum([TOTAL EXPENSES])), MARKET, Risk_Type)))

[swuehl · Accepted solution]

Maybe like

If(Dimensionality()<2,

Sum(Aggr(

If(SUM( [TOTAL EXPENSES])>0,SUM( [TOTAL EXPENSES]))

,MARKET,Risk_Type))

,

SUM([TOTAL EXPENSES]))

[Anonymous]

Perfect... Its working fine... Thank you..