ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/99439-pivot-table.html)

Newtonboy

Pivot Table
 

Hi,

How do i use results from the pivot table to perform some calculations
and show in the same pivot table ?

Ajit


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=561694


Mallycat

Pivot Table
 

set up your pivot table. On the pivot table menu, select Pivot
Table\Formulas\Calculated field. You can create new data using this
approach, then they form part of the pivot table.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561694



All times are GMT +1. The time now is 12:21 AM.

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