'Google sheets pivot table - display totals at the top
Is that possible to change pivot table totals row location in Google Sheets so that they display directly under the pivot headers? I have browsed the available options and tried googling but no answer.
Solution 1:[1]
This article describes a couple of ways to extract totals from a pivot table, either the whole row, or individual columns. This should let you build a "Totals" row on top of (above) where you are displaying the pivot table.
Solution 2:[2]
Another Workaround is, to create another Pivot-Table on top and delete the Rows. Greetings
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | halfer |
Solution 2 | Maurice |