Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to increase calculations speed in pivot table with calculated fields & items | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Creating Calculations Within a Pivot Table Field | Excel Discussion (Misc queries) | |||
Setting up "Year to Date" Calculations in a Pivot Table | Excel Worksheet Functions | |||
pivot table calculations | Excel Discussion (Misc queries) |