Excel Magic Trick 1203


2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change

DESCRIPTION

See how to:
(00:08) Problem Setup: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change
(00:48) Create PivotTable
(01:21) PivotTable Group by Month
(01:57) PivotTable Report Layout
(02:15) PivotTable Options: Prevent Column Widths from Changing on Refresh: uncheck “Autofit column widths on update”
(02:37) PivotTable Number Formatting
(02:50) Copy and Paste PivotTables
(03:10) PivotTable Show Values As: Running Total (Cumulative Sum)
(04:08) PivotTable Show Values As: Change from Previous Month
(04:54) PivotTable Show Values As: % Change from Previous Month
(05:40) Add Slicer for Product and Company
(06:53) Report Connections to connect all Pivots to Slicers
(07:05) Name PivotTables
(07:44) Report Connections to connect all Named Pivots to Slicers
(08:04) Slicer Settings to hide items in Slicer with no data: uncheck: “Hide items with no data”

WORKBOOKS







1 Comment

  1. Dear Sir,
    I want to learn your excel magic trick #185 & 186, How to extract rector.
    But I do not understand the formula.
    Can you explain step by step how to write the formula
    The first one, which formula
    after add what formula
    after
    after
    …….

Leave a Reply