Sales Variance Table in Excel (PY-AC-FC-PL)
Zebra BI for Excel
Overview
This sales variance table features a hierarchical table showing Market/Country performance. In one report, you can add up to 3 comparisons to the actual performance (AC): the plan (PL), previous year (PY), and forecast (FC). 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
