Hi Guys,
I need help...I am building a Pivot table and I need to show ONLY the Grand totals at the end of the table. In the example below I want to show only Total volume Stage movement at the end and not the subtotals in the columns. THANK YOU in advance
I need help...I am building a Pivot table and I need to show ONLY the Grand totals at the end of the table. In the example below I want to show only Total volume Stage movement at the end and not the subtotals in the columns. THANK YOU in advance
Column Labels | ||||||||||
Pipeline | Best Case | Commit | Closed | Total Value | Total VolumeStageMovement | |||||
Row Labels | Value | VolumeStageMovement | Value | VolumeStageMovement | Value | VolumeStageMovement | Value | VolumeStageMovement | ||
EMEA_NORTHERN | 15,511,556 | 8 | 15,633,485 | 4 | 7,071,877 | 5 | 1,823,840 | 2 | 40,040,759 | 19 |
EMEA_CENTRAL | 10,520,133 | 2 | 9,825,421 | 60 | 4,796,352 | 5 | 1,322,449 | 37 | 26,464,355 | 104 |
EMEA_SOUTHERN | 11,052,674 | 8 | 16,486,325 | 16 | 6,990,164 | 16 | 2,597,941 | 17 | 37,127,104 | 57 |
EMEA_EMERGING | 18,850,586 | 1 | 20,279,712 | 35 | 10,408,538 | 44 | 2,596,966 | 10 | 52,135,803 | 90 |
Grand Total | 55,934,949 | 19 | 62,224,943 | 115 | 29,266,931 | 70 | 8,341,198 | 66 | 155,768,021 | 270 |
Last edited by a moderator: