AngieNaude
New Member
- Joined
- Apr 29, 2021
- Messages
- 16
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
Hi! I have a sales pivot table showing products, companies who sold them, volume and value. I know how to switch on/off subtotals for rows and column fields but not for value fields. I am not sure if this is possible but what I am trying to achieve is to have the grand total of volume to be after the volume data and the grant total of the value then after the value data. Please see the sheet below with the arrow of where I want the data. This is such a basic question compared to what goes on in this page but this has me completely stumped