Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list sorted by a category with all of the hours associated with that category like this...
category x 20
category y 100
category z 75
I want to create a measure that's the percentage of the whole, so
category/(total sum of all the categories).
how do i go up a level in my formula to get the total sum of all the categories since it's already aggregated by category?
Have a look at the TOTAL argument of the sum() function.
Here is the Help entry for sum() that explains the TOTAL argument.
Have a look at the TOTAL argument of the sum() function.
Here is the Help entry for sum() that explains the TOTAL argument.
Thank you!