Tag: logical

Sync Slicers from Different Data Sets

Posted on by Annie D

Learn Excel – Sync Slicers from Different Data Sets

How can you have a slicer drive two pivot tables?
If both pivot tables came from the same data set: Select Slicer, Report Connections, Choose Other Pivot Tables
But if the pivot tables came from different data sets:
Use Save As to change the workbook extension to XLSM instead of XLSX
Use Alt+T M S and change macro security to second setting.
Alt+F11 to get to VBA
Ctrl+R to display the project explorer
Find the worksheet that contains your first pivot table and slicer
Insert the code for Worksheet_Update
Hide the second slicer away so it keeps existing but no one can ever choose from that slicer
via YouTube https://youtu.be/1fOeIS-UpNU

Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total

Posted on by Annie D

Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total

Download File:
Start File: http://ift.tt/2rKDr8N
Finished File: http://ift.tt/2sjWh3G
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
See how to use SUMIFS and SUMPRODUCT Functions to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column Header Criteria.
Related Videos:
Excel Magic Trick 1439: DAX Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
via YouTube https://youtu.be/KI0JQQuBJZc