+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Not Reading Percentages Appropriately

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Pivot Table Not Reading Percentages Appropriately

    Hello All, hopefully an easy one here. I have a pivot table that, because I need to break out quarterly information for a separate dashboard tab, have broken out by quarter from the original pivot table, that I then recreate second pivot tables for each quarter, so that quarterly charts on a dashboard are updated dynamically (through macros on a dashboard tab).

    I am sure there is a better way to create the dashboard altogether however my issue in the current setup is the second pivot table is not reading the percentages appropriately from the formulaic copied table, as I need it to be a simple "as is" read.

    I have attached a sample since the above probably makes very little sense, which includes the above descriptions next to each table to clarify. Unfortunately due to file size restrictions, was only able to recreate a small sample sans the dashboard, so please feel free to let me know of any additional questions to help clarify.

    Thank you for any assistance, appreciate it. This has been one of those never ending reports that keeps popping up new issues and prolongs the delivery of it!

    Thanks.
    Sheryl
    Attached Files Attached Files
    Last edited by sherylt13; 09-26-2015 at 01:00 PM.

  2. #2
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Pivot Table Not Reading Percentages Appropriately

    Hi.

    Did you try changing the number format in source data to number instead of %. This should help.

    VKS

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Only getting 100% on pivot table for row percentages
    By darq in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 03-18-2013, 05:30 AM
  2. Pivot Table with percentages and filter
    By captown in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2012, 07:28 AM
  3. Pivot Table reading equations/macros
    By DawginAuburn in forum Excel General
    Replies: 0
    Last Post: 02-07-2011, 05:19 PM
  4. Pivot Table percentages
    By jswarb001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-14-2008, 04:28 AM
  5. Pivot Table with Percentages
    By roly in forum Excel General
    Replies: 0
    Last Post: 04-11-2007, 09:40 AM
  6. pivot table not reading date formats
    By Todd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-20-2006, 02:05 PM
  7. [SOLVED] Pivot table - arranging data appropriately before performing pivot
    By Ben123 in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 10:45 AM
  8. Replies: 0
    Last Post: 03-16-2006, 07:20 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1