How to make the sum of three columns having cumulative data in qlikview pivot table

[kishorj1982]

How to make the sum of three columns having cumulative data in qlikview pivot table  

[kishorj1982]

In my pivot table

rangesum(Above(sum(ThirdPartySales ),0,RowNo(Total)))+

rangesum(Above(sum(WODistribution ),0,RowNo(Total)))+

rangesum(Above(sum(SalesOrder ),0,RowNo(Total)))

Expression giving wrong results.

Thanks

[pradosh_thakur]

try label name of first column+ label name of second column +label name of third column

[Anil_Babu_Samineni]

i am sure, I am going with unnecessary comment. But, Try a luck

rangesum(Above(RangeSum(sum(ThirdPartySales),sum(WODistribution),sum(SalesOrder))  ,0,RowNo(Total)))

OR

sum(Aggr(Above(RangeSum(sum(ThirdPartySales),sum(WODistribution),sum(SalesOrder))  ,0,RowNo(Total)), Dimensions))

[kishorj1982]

Thanks Anil,

This is working.

But I am not able to divide above column by

If(Month_Turns ='Jun', vBasePrice, vBasePrice+InventoryValue_USD))

Thanks

[Anil_Babu_Samineni]

Those are the variables? If so, Please share definition of each variable

[kishorj1982]

vBasePrice=Sum({<Month_Turns = {'Jun'}>}InventoryValue_USD)

[Anil_Babu_Samineni · Accepted solution]

Try this way

If(Month_Turns ='Jun', $(vBasePrice), $(vBasePrice)+Sum(InventoryValue_USD))

[kishorj1982]

Thanks Anil,

But in pivot table I am not able to show total row.

For Total row I am using below condition,

if(Dimensionality()=0,(sum(Cogs_Value_USD)/(sum(InventoryValue_USD)/2)*-1)/$(vFXFormat),

(((((rangesum(Above(RangeSum(sum(ThirdPartySales),sum(WODistribution),sum(SalesOrder))  ,0,RowNo(Total))))

/

If(Divide ='12', $(vBasePrice), $(vBasePrice)+Sum(InventoryValue_USD)))

/

$(vDivide))

/2)*-1)/$(vFXFormat))

Please siggest.

thanks

[Anil_Babu_Samineni]

In pivot table, You must use Sum(Aggr(YourExpression), Dim1, Dim2))