Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you send your .qvf file with sample limited data