Is there a way to view what I assume to be a pivot table in the “Yearly Budget Filter” sheet? I am trying to edit or recreate this table. Picture below:
The Yearly Budget Filter uses formulas embedded in the sheet to produce the report.
It’s not done with a pivot table.
Pivot table are a great way to get many reports and views of your data.
But using formulas gives you much more flexibility on the design.