| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show only the subtotals and grand total in a pivot table
Morning! I have a pivot table and I need to create another report from this
pivot table that only shows the sub totals and totals . How do I do this? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show only the subtotals and grand total in a pivot table
You could create another pivot table, based on the first one, and show
only the fields that you want summarized. Wanna Learn wrote: Morning! I have a pivot table and I need to create another report from this pivot table that only shows the sub totals and totals . How do I do this? thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show only the subtotals and grand total in a pivot table
Debra Excellent..... thanks
"Debra Dalgleish" wrote: You could create another pivot table, based on the first one, and show only the fields that you want summarized. Wanna Learn wrote: Morning! I have a pivot table and I need to create another report from this pivot table that only shows the sub totals and totals . How do I do this? thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show only the subtotals and grand total in a pivot table
You're welcome, and thanks for letting me know that it helped.
Wanna Learn wrote: Debra Excellent..... thanks "Debra Dalgleish" wrote: You could create another pivot table, based on the first one, and show only the fields that you want summarized. Wanna Learn wrote: Morning! I have a pivot table and I need to create another report from this pivot table that only shows the sub totals and totals . How do I do this? thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
