Share of total in columns pivot table

[guyvermeiren]

Hello,

I have a pivot table where the selected years (dimension) are the headers of my colums with as expression the Count of Actions with subtotals for the Type of actions. So the result is for each year the number of Actions by Type. Now I want to show my data as a percentage (share) of the toal for each column.

How ??

Kind regards,

Guy

[sparur · Accepted solution]

If I understood you should create expression like this:

count(Action) / count(TOTAL <TypeOfAction> Action)

[guyvermeiren]

Hi,

Thanks, this works perfect. I only replaced action by Year.

Kind regards