How to display exact values in pivote table in case it is a % data source

MGadAllah

New member
Joined
Jan 11, 2014
Messages
22
Reaction score
0
Points
0
Excel Version(s)
2016 and 2019
Hi,

Using Excel 2010 32bit x86.

I am making a very simple clean model for call center calls to report various kind of information about all calls.

The excel workbook is attached

As you can see in the attached worksheet I've created a sheet for data entry titled Data-Entry where I can fill in values for count of calls (sorry if you realize illogical numbers because I've used the random numbering of cells without duplicate - ASAP Utilities).

The data I will fill in manually is the data exist in cells with yellow colors and all the rest to the right will be processed as a result of the equations I've filled in.

I've no problem with sheets (Data-Entry - Calls-Report - Net-Calls-Report) so far.

My problem is the data shown in pivot table in sheets (Today Calls-Report (%) - Total-Calls-Report (%) ) ... as you can see I can not show them correctly as I need.

My question is => How to display result shown in sheets {Today Calls-Report (%) - Total-Calls-Report (%) } in % format instead of the current formats ?


https://www.dropbox.com/s/rra3ccljb8c0bvf/survey_final_excelguru_forum.xlsx
 
Back
Top