Results 1 to 14 of 14

Only getting 100% on pivot table for row percentages

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2013
    Location
    bath
    MS-Off Ver
    Excel 2007
    Posts
    23

    Only getting 100% on pivot table for row percentages

    Hi, I am struggling to make a pivot table give me percentages. I am fairly new to them and just need this graphs to display each number field, i.e. 7, 8 and 9 as percentage of the other 3 factors in the field. I notice there are no row totals in the pivot data table despite adding the grand totals for rows in options. I attached below (hope it works) the excel with 2 spreadsheets one without any % and another with (total of row % on the 4 tags) but it just shows 100% whatever I do. Any help greatly appreciated!

    Percentage Problem2.xlsx
    Attached Files Attached Files
    Last edited by darq; 03-17-2013 at 10:34 AM.

Thread Information

Users Browsing this Thread

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

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