hello everyone.



my knowledge of Excel is very rudimentary.

I have to do a pivot (please find attached).

this is about Call centre information.

the data is made up of an Area_Group (where the calls are generated from), a Destination (to where to call was made), Trn - which is the amount of call transferred to a Destination, and a TOTAL volume for every Area_group.

I have to calculate the % of Trn / Total Volume per Area Group (and supposedly all of those %'es should add up to 100% per Area_Group)

if you have a look at the attachment - the calculated ratio all work out at 100% which is impossible!

(I have created a calculated field that does this calculation called Ratio)

what am I doing wrong?

all help will be appreciated

Thank you

Attached Files

TransferDestination - April 2016.xlsx (58.3 KB, 10 views)