Problem with pivot table total

[riho92qv]

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

[Anil_Babu_Samineni]

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))

[riho92qv]

Hi

Thanks Anil, it works fine. I also tried to use Aggr function, but I forgot add dimenions and get 0 values.

Riho

[Anil_Babu_Samineni]

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?