Discover the trick to connect Data Type with a slicer. This trick will transform your dashboard to another level of analyse.
All the explanations are detailed in this article
https://www.excel-exercise.com/connec...
00:00 Introduction
00:12 What is Data Type
01:27 Create a Table with your field and an ID
04:02 Insert the slicer of the column of the Table
04:27 Function SUBTOTAL
05:36 Embedded the result in the function XLOOKUP
06:26 Creation of the formula with FIELDVALUE
08:34 Correct the N/A error if there is no selection
09:22 Correct the SPILL Error when Data Type return more than one result
10:15 Add new field for the slicer
Watch video Use Data Type with a slicer - How to connect them? online without registration, duration hours minute second in high quality. This video was added by user Excel Exercice 18 November 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,213 once and liked it 18 people.