Calculations in Pivot Table
I would like the pivot table to show three computed calculations, like:
Length Avg St Dev Count Type 1 Type 2 Type 3 etc. Is there some way to do this in one swell foop, or should I just create the pivot table three times, and copy the data to a new worksheet? Thanks in advance. |
Calculations in Pivot Table
I think it is possible. I have done it with two columns - SUM and COUNT.
See if this helps http://www.contextures.com/xlPivot02.html There are more links for PivotTable info in that site. Epinn "pdberger" wrote in message ... I would like the pivot table to show three computed calculations, like: Length Avg St Dev Count Type 1 Type 2 Type 3 etc. Is there some way to do this in one swell foop, or should I just create the pivot table three times, and copy the data to a new worksheet? Thanks in advance. |
All times are GMT +1. The time now is 10:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com