Qliksense: Pivot column based on condition and how change the global totals

I am new in Qliksense. I have a problem with a pivot table. I would like to change this table based on condition: if [Real Cost] > 0 then Invoice (USA + ITA) else Invoice(USA + ITA) = 0. I would like that the Totals changes without counting the number 2000. Is it possibile to do something like that? I tried to do this; I calculated the Invoice (USA + ITA) column with this condition: =if([Real Cost] <> 0, [Invoice (USA + ITA)], 0) this works fine but the totals are still the same. How can I resolve this kind of problems?