Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a problem with pivot table column total value
Problem is actual for me only in last column. I undestand that value 48 411,36 = 2,80 * 17320, but i need there sum of values in last column, and this sum is 33 898,13.
Can anyone help me. I will attach fragment of my Qlikview file.Thank you for any help.
Riho
PFA
=Sum(Aggr(if(Sum({$ <Year = {"$(=min(Year))"}>}ExtCost)=0 Or Sum({$ <Year = {"$(=max(Year))"}>}ExtCost)=0,
0, (Sum({$ <Year = {"$(=min(Year))"}>}ExtCost) / Sum({$ <Year = {"$(=min(Year))"}>}OurQty)
-Sum({$ <Year = {"$(=max(Year))"}>}ExtCost) / Sum({$ <Year = {"$(=max(Year))"}>}OurQty)) * Sum({$ <Year = {"$(=max(Year))"}>}OurQty) )
,PartGroup, PartNum))
Hi
Thanks Anil, it works fine. I also tried to use Aggr function, but I forgot add dimenions and get 0 values.
Riho
Great, Not sure why you draw in Pivot table? Even, If you change it to Straight table using (Sum option) will deserve.
Please close this thread by flag correct answer and helpful for other response?