ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW TO INSERT A CALCULATED FIELD TO MY PIVOT TABLE EXCEL 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/128209-how-insert-calculated-field-my-pivot-table-excel-2003-a.html)

drhell

HOW TO INSERT A CALCULATED FIELD TO MY PIVOT TABLE EXCEL 2003
 
Please help me out, i want to add a new fiel called (SUM_OF_TWO). Thanks...

Roger Govier

HOW TO INSERT A CALCULATED FIELD TO MY PIVOT TABLE EXCEL 2003
 
Hi

From the Pivot Table Toolbar, use the dropdown and select
FormulasCalculated FieldName Sum_of_Two
Formula = whatever calculation you want to make upon the other fields
within your PT.

--
Regards

Roger Govier


"drhell" wrote in message
...
Please help me out, i want to add a new fiel called (SUM_OF_TWO).
Thanks...





All times are GMT +1. The time now is 04:47 AM.

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