Thread: [Solved] Pivot Problem
View Single Post
 
Old 05-07-2016, 04:05 AM
lornalou lornalou is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2016
Posts: 5
lornalou is on a distinguished road
Angry 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
Attached Files
File Type: xlsx TransferDestination - April 2016.xlsx (58.3 KB, 10 views)
Reply With Quote