Use expression total in a new calculation

[#1]

Guys hopefully someone is able to help me with the following:

I have a pivot table with a dimension Categories and an Expression with Hours.

I checked the Expression total and this works. What I need is a new expression to calculate the % percentage hours from the expression total. Is there a way to use the Expression total in a new expression?

[sinanozdemir]

Hi Bart,

I believe you can achieve that by using Total or All in your aggregation functions. Please see below:

To get the overall expression total, I used Sum(All Amount) and to get the overall expression total by Sites, I used Sum(Total<Site> Amount) expression.

Hope this helps.