Total row in pivot table

[JustynaK]

Hi,

I have a problem with pivot table that is built based on valuelist. I have several different measures in the columns. In column B I need to have values from column D but only for those rows where Column C>0. I tried to calculate B in many ways, with 'if', flags from script.. However, still I can get the correct values in rows but wrong total value of 47019,07.

Is there a way to give in total only the sum of rows underneath?

thanks

[NitinK7]

can you send your .qvf file with sample limited data