Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2010, 04:11 AM
swindon swindon is offline Pivot table problem Windows XP Pivot table problem Office XP
Novice
Pivot table problem
 
Join Date: Jan 2010
Posts: 5
swindon is on a distinguished road
Default Pivot table problem

Hi all



I was hoping someone might be able to help me. I've got a problem with this pivot table:

In your opinion, how good a job do you think the police are doing in your local area?Count of A1QUARTERA1Total1Excellent29Good179Fair127Poor36Very Poor71 Total3782Excellent34Good203Fair149Poor37Very Poor162 Total4393Excellent30Good181Fair112Poor29Very Poor163 Total3684Excellent23Good173Fair105Poor33Very Poor134 Total347Grand Total1532

Essentially the totals are displayed at the moment as counts. I want to display each one by a % of the "Quarter" they are in. I can get a % of the grand total but not of the sub-totals. % of row or column obviously doesn't work. When I pick Quarter as a Base Field I then need to specifiy a Base Item, but this needs to vary depending on the quarter. Does anyone have any advice?

As a practical example, the first line shows "Excellent" as 29 for quarter 1. I need this to show as a % of 378, the first sub total, not of the grand total. The second "Excellent" needs to show as a % of 439, and so forth.

I can't seem to upload the document which I know is a pain.

Any help would be very gratefully recieved, and would really speed up my work on this report.

Many Thanks

swindon
Reply With Quote
  #2  
Old 05-25-2010, 04:11 AM
swindon swindon is offline Pivot table problem Windows XP Pivot table problem Office XP
Novice
Pivot table problem
 
Join Date: Jan 2010
Posts: 5
swindon is on a distinguished road
Default

In your opinion, how good a job do you think the police are doing in your local area?Count of A1QUARTERA1Total1Excellent29Good179Fair127Poor36Very Poor71 Total3782Excellent34Good203Fair149Poor37Very Poor162 Total4393Excellent30Good181Fair112Poor29Very Poor163 Total3684Excellent23Good173Fair105Poor33Very Poor134 Total347Grand Total1532
Reply With Quote
  #3  
Old 05-25-2010, 04:12 AM
swindon swindon is offline Pivot table problem Windows XP Pivot table problem Office XP
Novice
Pivot table problem
 
Join Date: Jan 2010
Posts: 5
swindon is on a distinguished road
Default

Sorry, please ignore, pivot table won't copy and paste. Will find another way to show it.
Reply With Quote
  #4  
Old 05-25-2010, 04:14 AM
swindon swindon is offline Pivot table problem Windows XP Pivot table problem Office XP
Novice
Pivot table problem
 
Join Date: Jan 2010
Posts: 5
swindon is on a distinguished road
Default

1Excellent29Good179Fair127Poor36Very Poor71 Total3782Excellent34Good203Fair149Poor37Very Poor162 Total4393Excellent30Good181Fair112Poor29Very Poor163 Total3684Excellent23Good173Fair105Poor33Very Poor134 Total347Grand Total1532
Reply With Quote
  #5  
Old 05-25-2010, 04:18 AM
swindon swindon is offline Pivot table problem Windows XP Pivot table problem Office XP
Novice
Pivot table problem
 
Join Date: Jan 2010
Posts: 5
swindon is on a distinguished road
Default

Attached copied into word instead. Hope that's clear. Can anybody advise please?

Cheers

swindon
Attached Files
File Type: doc survey data.doc (43.0 KB, 4 views)
Reply With Quote
  #6  
Old 05-25-2010, 02:05 PM
Kimberly Kimberly is offline Pivot table problem Windows 7 Pivot table problem Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Make Quarter be the column field. make the other field be both the Row field and the Data (values to be counted) field.

Right-click on one of the counts and choose Value field Settings.
Go to the Show Values As tab
UIse the drop-down to choose Show value as % of column total
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table problem Pivot Table's fields janis129 Excel 7 03-02-2010 03:16 PM
Excel pivot table into an MS Word Doc "office 2007" wmarsh3561 Excel 1 01-09-2010 08:03 PM
word catalog table layout problem... turk1130 Word Tables 0 08-01-2006 11:56 AM
Corrupt table problem... MoniqueB Office 0 01-06-2006 08:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft