Pivot Problem
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
|