Pivot Table with Column Percentages

[wonkymeister]

Hi,

I have a pivot table, with YEAR across the top (3 years so 3 columns), with the user being able to select from a list of available dimensions down the side.

I need the % to calculate for each individual column (year), as opposed to a percentage of the total.

Any ideas?

[jmvilaplanap]

I think no, because there is in a pivot table, then automatically the results are "filtered" to fit each cell, is because you need to use "TOTAL"

It will be possible to use it in a text object using filters, but I think is not that are you looking for.