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