Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table question
A client wants to create a pivot table in Excel 2003 where the values
in the data section of the table have had no operations (sum, product, etc) performed on them. Is this possible? As well I have another client that wants to get find the maximum value and the minimum value out of a a colmn in a pivot table). I tried using the getpivotdata function but it is not returning the values I need. Thoughts? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table question
A pivot table summarizes the fields that are put in the data area, so
you can't put something there with no summary function. You can add the fields to the row area, where they'll be visible, and add a different field to the data area. The GETPIVOTDATA function will extract specific values from a pivot table, but doesn't help you find the maximum in a section of the pivot table. You could use MAX and MIN functions outside the pivot table, if the layout doesn't change frequently. Kevin wrote: A client wants to create a pivot table in Excel 2003 where the values in the data section of the table have had no operations (sum, product, etc) performed on them. Is this possible? As well I have another client that wants to get find the maximum value and the minimum value out of a a colmn in a pivot table). I tried using the getpivotdata function but it is not returning the values I need. Thoughts? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | New Users to Excel | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) |