Using PivotTables in Excel can help you get quick summaries (counts and totals) of various fields on reports, listed by whatever criteria you need—ribbon color, exhibitor, department, etc. Although the term “PivotTable” is not terribly user-friendly, these are not difficult to create, once you have exported a report containing the correct data to Excel.
The menu bars and options vary slightly between versions of Excel. The screenshots in these documents are from Excel for Windows.
**NOTE: Results Budgets must be finalized before results fields (ribbon, points, premium, etc.) will populate on Custom Reports.
- FairEntry.PivotTables.RibbonCount outlines the process for using the Standard Report - Results for Media - to create ribbon counts. The Results for Media report lists ribbons received even before budgets are finalized.
- FairEntry.PivotTables.TotalPoints and FairEntry.TotalPremiumsFees both rely on custom reports, so it's important to have finalized your budgets.