Problem:  Revenues were budgeted by Customer and Segment.  Actual reporting required so many pages that it was difficult to understand where volume was significantly varying from Budget.

Solution:  Calculate variance of Actual to Budget and just display that by Customer and Segment.  Further, Identify top 10 vs. All Customers. 

Results:   All Sales reporting (Period and Year-to-Date) are accomplished on two pages.

Tools Used:  Excel Data Models “Measures”.  Measures are a powerful feature that complete calculations outside the spreadsheet and return results in Power Pivot Tables.