I know you can add subtotals in pivot tables, but can you add subtotals in pivot charts?
Below is a small sample data. I would like a subtotal in chart for the Report Year.
Thank you.
Report filters: None
Legend Fields (Series): Type
Axis Fields (Categories): Report Year
Values: Sum of Values
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Below is a small sample data. I would like a subtotal in chart for the Report Year.
Thank you.
Report filters: None
Legend Fields (Series): Type
Axis Fields (Categories): Report Year
Values: Sum of Values
Report Year | Type | Value |
2014 | A | 4 |
2014 | A | 5 |
2014 | A | 4 |
2014 | A | 4 |
2014 | B | 5 |
2014 | B | 6 |
2014 | B | 5 |
2014 | C | 4 |
2014 | C | 5 |
2014 | C | 6 |
2014 | C | 5 |
2014 | C | 4 |
2014 | C | 5 |
2014 | D | 8 |
2014 | D | 5 |
2015 | A | 7 |
2015 | A | 2 |
2015 | A | 8 |
2015 | A | 9 |
2015 | B | 1 |
2015 | B | 8 |
2015 | B | 2 |
2015 | C | 3 |
2015 | C | 8 |
2015 | C | 2 |
2015 | C | 7 |
2015 | C | 1 |
2015 | C | 2 |
2015 | D | 9 |
2015 | D | 7 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>