Is there a way to create a value column that totals the other columns in a pivot table? I'm looking to show a table of fiscal years as columns with campaigns as rows, showing the total for each fiscal year as well as the full multi-year campaign. I can get the rows to sum, but not sure how to add a column at the far right that totals certain columns if that's even possible. Thanks for any thoughts!
Hi Keri,
It sounds like you're looking for this little nugget... Grand Totals on Columns?
Game. Changer. I had no idea that function was there! Thank you!