Total is not displayed for pivot table

[kishorj1982]

Hi all,

PFA.

I am using rangesum function but I am not able to display total row.

For total row I need to use other formulae.

and for rest other.

Please suggest.

[Anil_Babu_Samineni]

PFA

=Sum(Aggr((((((rangesum(Above(RangeSum(sum(ThirdPartySales),sum(WODistribution),sum(SalesOrder))  ,1,RowNo(Total))))

/ If(Month_Turns ='Jun', $(vBasePrice), $(vBasePrice)+Sum(InventoryValue_USD))))/2)*-1), BranchPlant, DtDate))