Please help me to resolve the total issue in pivot table, based on the condition I want to show the sum after that in top column wise total .
Eg: if(rangesum(above(total sum(A),0,Rownno(total)))<=Sum(B),Sum(A),0)
result of total is not coming correctly.
please have a loo the screen shot.
As you see the conditional value total is not coming correctly.
Thanks, I can use that one but after If I have one more if condition and the above expression gives the result same like sum(Sales), which I don't want,
My expression is :
if(rangesum(above(total sum(A),0,Rowno()))<Sum(B),Sum(A), if(Rangesum(above(Total Sum(A),1,Rowno()))<Sum(B),Sum(B)-Rangesum(above(Total Sum(A),1,Rowno())),0))
in that condition , I m not getting the correct grand total
but it's working fine for all row except grand total, I need the condition value expression only.
Actually I want to achieve the cumulative sum based on the column wise