Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ray D
 
Posts: n/a
Default Pivot table. Calcualting % from subtotals.

Hi, All!

I have such pivot table:
Answer2
Quest1 Answer1 male female
Do you have a hobby? Yes 5 10
No 3
4
Total 8 14
Do you smoke? Yes 7 3
No 2 7
Total 9 10
etc...
Grand Total ...

How can calcualte in the data area percent of the total sum in column? "%
from column" calculates it from the Grand Total.

Thanx in advance...
  #2   Report Post  
Ray D
 
Posts: n/a
Default

Maybe I need to change source data somehow?

"Ray D" wrote:

Hi, All!

I have such pivot table:
Answer2
Quest1 Answer1 male female
Do you have a hobby? Yes 5 10
No 3
4
Total 8 14
Do you smoke? Yes 7 3
No 2 7
Total 9 10
etc...
Grand Total ...

How can calcualte in the data area percent of the total sum in column? "%
from column" calculates it from the Grand Total.

Thanx in advance...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 06:32 PM
pivot table, functions for subtotals Massimo Excel Worksheet Functions 2 January 23rd 05 08:59 AM
Pivot table subtotals 100% JaniceHill Excel Discussion (Misc queries) 1 December 17th 04 12:51 AM
Pivot table subtotals 100% JaniceHill Excel Discussion (Misc queries) 0 December 16th 04 03:43 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 02:18 PM


All times are GMT +1. The time now is 09:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"