How to get Grand Totals on Top for Excel Pivot Tables?

4 simple tricks 💥 to get grand totals on top for Excel pivot tables. Normally Excel won't allow you to place pivot table grand totals on top. But you can apply these tricks to get grand totals right where you want them.

1. Use 2 pivots instead
2. Use GETPIVOTDATA formula
3. Cell references or simple formulas
4. Use CUBE formulas

In this video, I will explain all these tricks with demos.

For sample file, visit:

https://chandoo.org/wp/wp-content/upl...

Timestamps:

0:00 - introduction
1:50 - Using 2 pivot tables to get grand totals on top
4:02 - GETPIVOTDATA method
5:40 - Cell references & XLOOKUP method
8:21 - CUBE formula approach
12:06 - Recap of all 4 methods


More on Pivot Tables:

Introduction - https://chandoo.org/wp/excel-pivot-ta...
Data model & relationships - https://chandoo.org/wp/introduction-t...
Time saving tricks - https://chandoo.org/wp/pivot-table-ti...
Advanced Pivot Table tricks - https://chandoo.org/wp/advanced-pivot...

Playlists on Pivot Tables:

Pivot Tables: Analyze data quickly with Pivot Tables
Advanced Pivot Tables: Advanced Pivot Table Tricks


#PivotTables #ExcelTricks

• #science_technology
• #chandoo
• #chandooorg
• #excel
• #spreadsheets
• #grand_totals_on_top_for_pivot_tables
• #show_grand_total_row_on_top_in_excel
• #excel_pivot_table_customize_grand_total_row
• #move_grand_totals_in_pivot_table