Hi all, newbie to the forum here.
Can anyone help with this issue that I'm having with percentages. I want a calculation to show a percentage of a value in a row, not of the column (in green).
For example:
Not Started Preparing Submitted Total % not started % preparing % submitted
Service Area 1 266 78 328 672 40% 12% 49%
Service Area 2 2 0 1 3 67% 0% 33%
So the individual rows add back to 100%, not the columns.
I'm probably missing something completely obvious here!
I would probably do that as new calculated columns, PercentageNotStarted = [Not Started] / [Total] etc.
I did try that but for some reason it wasn't returning the correct results. I'll have another shot and play around with the aggregation methods.
Did you manage to get it to work for you?