Cross-Tabs: Rows × Columns with UNIQUE, TRANSPOSE and One SUMIFS Grid
This lesson is part of the course
In this lesson
You build Brightwater's revenue matrix, regions down and categories across, with a header formula, one grid formula and row and column totals.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Row Labels: What a PivotTable Does, Rebuilt with UNIQUE and SORT Locked
- Values: SUMIFS over the Spilled Labels (H2#) Locked
- Cross-Tabs: Rows × Columns with UNIQUE, TRANSPOSE and One SUMIFS Grid Locked
- Show Values As: % of Grand Total, % of Row and % of Column Locked
- Count, Average, Max and Distinct Count: COUNTIFS, AVERAGEIFS, MAXIFS Locked
- Report Filters: Criteria Cells, (All) and a Drill-Down List Locked
- Grouping Dates by Month and Quarter: EOMONTH and Text Keys Locked
- Capstone: A Subtotal Report, a Summary that Ignores It, and a Chart Locked