Sales Variance Table in Excel (PY-AC-PL)
Zebra BI for Excel
Overview
This sales variance table features a hierarchical table showing Market/Country performance. It enables you to compare the actual performance (AC) with the plan (PL) and previous year's numbers (PY) within one table. The absolute and relative variances are calculated automatically, and you can add dynamic comments to explain the numbers further.
Get started in 3 steps
1
Download & Open
Download the .xls file and open it in Excel
2
Connect Your Data
Replace sample data with your CRM, ERP, or database source
3
Customize & Publish
Adjust KPIs, colors, and branding, then publish to Power BI Service
Fill out the form and get the Excel template
20,000+ users have downloaded this template
