Percentage of rows rather than columns

[missspeedy23]

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!

[BigChris]

I would probably do that as new calculated columns, PercentageNotStarted = [Not Started] / [Total] etc.

[missspeedy23]

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.

[BigChris]

Did you manage to get it to work for you?