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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com