ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Place all subtotals at bottom of pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/99169-place-all-subtotals-bottom-pivot-table.html)

Air_Cooled_Nut

Place all subtotals at bottom of pivot table?
 

Is there a way to put all of the subtotals in a pivot table at the
bottom (directly above the Grand Total) of the pivot?


--
Air_Cooled_Nut


------------------------------------------------------------------------
Air_Cooled_Nut's Profile: http://www.excelforum.com/member.php...o&userid=15730
View this thread: http://www.excelforum.com/showthread...hreadid=561229


Dave Peterson

Place all subtotals at bottom of pivot table?
 
You mean not near the break in values?

Nothing like that that's built into excel that I've seen.

Air_Cooled_Nut wrote:

Is there a way to put all of the subtotals in a pivot table at the
bottom (directly above the Grand Total) of the pivot?

--
Air_Cooled_Nut

------------------------------------------------------------------------
Air_Cooled_Nut's Profile: http://www.excelforum.com/member.php...o&userid=15730
View this thread: http://www.excelforum.com/showthread...hreadid=561229


--

Dave Peterson

Air_Cooled_Nut

Place all subtotals at bottom of pivot table?
 

Dave Peterson Wrote:
You mean not near the break in values?

Yup ;) ;)


--
Air_Cooled_Nut


------------------------------------------------------------------------
Air_Cooled_Nut's Profile: http://www.excelforum.com/member.php...o&userid=15730
View this thread: http://www.excelforum.com/showthread...hreadid=561229



All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com