Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.