Is it possible to hide the total on one column in a pivot table

[#1]

I'm using totals in a pivot table but would like to hide the total value in one of the columns as it does not accurately represent the data for that column. Is this possible?

[#2]

Hi Wvogt,

I am not sue whether there is a setting for this but you could try the following:

The 'Totas'' row number for any column is 0. So if you use an 'If' condition, in the expression, this may work. eg.

if you expression is Sum(Qty), you could change it to

=if(rowno()=0,'-',Sum(qty))

Nimish

[#3]

Nimish,

That's exactly what I needed.

Thank you very much

Ward

[#4]

Thank you Nimish, this helped me as well 🙂

Regards Steve