Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In Excel 2002, I get the wrong value (inaccurate) from a calculated field
that is supposed to provide the simple difference between two other data fields; "% 2002 Total - % 2001 Total" The data fields "% 2002 Total" and "% 2001 Total" are created using the "% of Total Option" in the Pivot Table Field Settings menu. Any suggestions for a fix, or explanation would be most appreciated. Note: I need to use a calculated field inside the Pivot Table. I realize a calculation outside the Pivot Table would be a work around. -- thanks, Marshall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Creating Calculations Within a Pivot Table Field | Excel Discussion (Misc queries) | |||
pivot table field name error | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |