Results 1 to 2 of 2

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

  1. #1
    Acolyte MGadAllah's Avatar
    Join Date
    Jan 2014
    Excel Version
    2016 and 2019

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

    Register for a FREE account, and/
    or Log in to avoid these ads!


    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 ?

  2. #2
    Excel 2010 with free PowerPivot Add-In
    Scrapped 99% of your original input.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts