PivotTables are amazing! Click a few buttons and generate an awesome dynamic report. However, they can be irritating due to their lack of flexibility. It is the PivotTable way or the highway.
Break through the PivotTable ceiling with formulas. When using data from a Table/Range, do not let PivotTables limit you. We can use all our favourite features and characteristics of PivotTables such as dynamic reports, Slicers and charts from formulas in a table.