note

[Excel Video Tutorial] How to add a breakdown to a PivotTable grand total (No DAX, brute ...

In this video, I will explain how to add a breakdown by product to the grand total of a summary table created with an Excel PivotTable. When you create a summary table in an Excel PivotTable, a grand ...
note

[Excel Power Pivot/DAX Video Tutorial] Aggregating items below a threshold amount as 'Other'

In this video, I will explain how to use a DAX measure formula to aggregate products with total sales below a threshold amount selected by a slicer into an 'Other' category. Learn Excel Power Query ...