Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If I understood you should create expression like this:
count(Action) / count(TOTAL <TypeOfAction> Action)
If I understood you should create expression like this:
count(Action) / count(TOTAL <TypeOfAction> Action)
Hi,
Thanks, this works perfect. I only replaced action by Year.
Kind regards