ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   caluclated field in pivot table? (https://www.excelbanter.com/excel-worksheet-functions/26329-caluclated-field-pivot-table.html)

marshall

caluclated field in pivot table?
 
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



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com