working out percentage of a total

[MarkoJemo]

Hello,

I'm wanting to work out the percentage of the activities vs total time taken from the dataset attached. Ideally I would have a column to the right of Sum of hours which looks at the total time and works out the percentage of each activity against the total time. I have had a play around with the formula tool but can't for the life of me solve this problem. Thanks in advance!!

[Luke_C]

Hi @MarkoJemo 

Isolate and append the total to your dataset, then you can use a simple formula to identify the %

[Felipe_Ribeir0 · Accepted solution]

Hi @MarkoJemo 

two ways of doing this:

[binuacs]

@MarkoJemo One way of doing this with the Transpose and the Cross tab tool