Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have a Pivot chart and I need to find a difference calculation.Please help me out.
Please find the attached Excel for more information.
Thanks in advance!
Something like if(below(Quantity)<>0,Quantity-below(Quantity),0)
Hi Gysbert,
Thanks for your reply.I tried the expression as you mentioned.But it's not working for all the cases, because I may randomly select the PW(say sometimes I can select 3 or 4 or 5 and so on).In those scenario it's not working.
Looking forward for your reply!
because I may randomly select the PW
And what result do you expect then?
Dear Gysbert,
Thanks!
When I am applying the the Expression given by you,I am getting the following result.
Expected Result is
Looking forward for your reply.
Gowthami
Please post a qlikview document that demonstrates the problem.
Hi
Try some thing like this,
if(bottom(Quantity,1)<>0,Quantity-bottom(Quantity,1),0)