Assuming we are in year 2018, the Year To Date filter will only show transaction recorded in year 2018, excluding other year.
if you interest to learn how to create this Variance Analysis using Pivot Table, please enroll our Excel Advanced Class. Thank you.
In our 2-day Excel Advanced class, you will learn:
- Excel Pivot Table
- Variance formula
- Using Macro with Pivot Table and more..