The 12M GP% Grid compares monthly gross profit percent year over year. This information is updated daily.

- Open this Dashboard as described in Review Sales dashboard KPIs
- Review gross profit %. In this example, assume you are viewing the dashboard on June 15, 2019.
- TY GP %: This Year's Gross Profit % . The gross profit % for each month this year, from yesterday to that same day last year (June 14 2018-June 14-2019).
- TY GP % Var: This Year's Gross Profit % Variance. The difference between TY Gross Profit % and LY Gross Profit %. In the chart above for Total:
**[(24.96%) - (24.42%)] = .54%**

This means the organization earned .54% more gross profit year over year. - TY GP % Var %: This Year's Gross Profit % Variance Percent, calculated as
**(TYGP%Var/LYGP%)100** - LY GP %: Last Year Gross Profit % . The gross profit percentage earned from a year ago yesterday and the prior year: in this example, the gross profit earned between June 14, 2017 and June 14, 2018.
- LY GP %Var: Last Year's Gross Profit % Variance. The difference between LY Gross Profit % and the prior year's Gross Profit % (3
^{rd}Y GP% not shown). In the chart above for Total:**[(24.42%) - (ThirdYearGP%)] = -.90%**

From this equation, you can calculate the Third Year Gross Profit % (2017-2018) as 25.32%. - LY GP %Var %: Last Year's Gross Profit % Variance Percent, calculated as

**(LYGP%Var/ThirdYearGP%)100**

- To filter the Gross Profit % by salesperson, vendor, or location, click View Detail.
From the Filter list, choose one of the filters below, and then select/clear the check boxes to define the specifics. Click Search.

Available filters- Salesperson
- Territory
- Branch
- Division
- Customer
- Primary Vendor
- Order Writer