Hello,
Please see attached image for reference.
I have a pivot table that shows the data broken out by Quarters in the columns and Year in the rows.
When trying to add subtotals for Division (BAL, KC) the subtotal combines both 2021 and 2022 values instead of splitting them.
Basically I was looking if there is a way for the subtotals to also show 2021 and 2022 like it is for the non-subtotals above.
Please see attached image for reference.
I have a pivot table that shows the data broken out by Quarters in the columns and Year in the rows.
When trying to add subtotals for Division (BAL, KC) the subtotal combines both 2021 and 2022 values instead of splitting them.
Basically I was looking if there is a way for the subtotals to also show 2021 and 2022 like it is for the non-subtotals above.