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

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 ?

survey_final_excel_forum.xlsx

Thanks a lot for your feedback.
I will apply what you said and feed you back.
Another question under the same topic, how can I show the result of the pivot table in a chart and when I change the filter for the pivot table to apply te changes automatically i the chart?

Originally Posted by Richard Buttrey

Hi,

Just add the chart of your choice from the Pivot Table Tools area after you've clicked on 'Pivot Chart'

I did but it only pick up one type of calls and not all types, like success only and now all the types, I hope if you may help me

I do like the 'Calculated field' trick a lot and I would like to listen to your advise and use it to save time and reduce file size.
Please in the data entry sheet there is a column titled Calls Today, I will apply the 'Calculated field' trick to it as well
And there is another column in the same sheet Data Entry titled Calls Before which is the total calls of all days before (please if you may check its formula and tell me if I can do the 'Calculated field' trick with it or not possible?)