Chart 3 - Top 6, Top 3 (similar to Chart 1)
Pie 3 (right) - picks data from sheet - Budget; COST pivot table from PIVOTS.
1. The Table COST should at all time be filtered by the Status OPN and then perform calculations.
2. When creating the Top 6 Reason Codes I would like to have the reason code ON-BDGT excluded from the results.
3. Top 3 will be the stores with the highest variances found in Column M of the Budget worksheet.
4. Would like the results to look as follows:
Partner- Site, 13s 25%
Mila-57115 - 57%
Jem-57675 - 54%
Stoc-56225 - 44%