Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt M HMS
 
Posts: n/a
Default PivotTable - Calculated Field

Thank you in advance for you effort

Current Pivot Set-up

week
1 2 3 TOTAL
SUBTOTAL %
X Y X Y X Y Total X
Total Y X Y

A) 3 10 5 12 11 25 19
47 * B) 1 9 2 6 8
15 11 30
C) 5 11 5 11 5 11 15
33
SUBTOTAL: 45
110
D) 6 15 8 17 15 30 29
62 #
TOTAL: 74
172

*I would like this percentage to have the following formula:
=19/45

# This percentage should have the following formula:
=29/74

How can I get this to work?

Matt

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
how to create a calculated field from another calculated field? Eldon Excel Discussion (Misc queries) 0 January 9th 06 03:40 PM
pivottable calculated fields HelpAl Excel Discussion (Misc queries) 3 December 8th 05 10:18 PM
PivotTable Calculated Item error [email protected] Excel Discussion (Misc queries) 1 September 28th 05 09:32 AM
Using a MIN, MAX formula on a calculated field in a pivot table fhaberland Excel Discussion (Misc queries) 0 August 2nd 05 07:47 PM
PivotTable - calculated items? Peter Aitken Excel Discussion (Misc queries) 1 July 4th 05 05:50 PM


All times are GMT +1. The time now is 01:08 PM.

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"