Pivot Table - Subtotals for C1 and C2
Hello,
I have a Pivot Table where I am looking to have totals for both C1 and C2 on the table. I have inserted an expression below the quarterly totals for each vendor but it is giving the total for the year including all vendors. I am looking to have each yearly total seperate for each vendor.
I am able to group this information by C1 (which shows the total Yearly spend for all vendors in the cell) and also have formatting to spread the columns out to the 4 quarters. I run into an error when I try grouping this data by R1C1 to give me the desired results of seperating the yearly total by vendor name and including the expression to size the cell to cover 4 columns. I am able to get the correct numbers when I exclude the formatting expression (NC) but it does not align correctly.