Pivot Table

[#1]

I Have a pivot table with some calculated columns.

If I set a total, then also the calculated columns will be totalized. Because some of the columns are percentages I don't want to totalize these columns.

How can I fix this?

[#2]

Hi,

Not sure if this is over-simplifying the problem but does selecting No Totals in the Total Mode area work?

Regards,

Jason.

[#3]

Hi, Thx for helping me.

No I can't select that switch.

[pkelly]

‌try the following

if(dimensionality() <> 0, your expression)