Use Data Type with a slicer - How to connect them?
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
On this page of the site you can watch the video online Use Data Type with a slicer - How to connect them? with a duration of hours minute second in good quality, which was uploaded by the user Excel Exercice 18 November 2021, share the link with friends and acquaintances, this video has already been watched 1,213 times on youtube and it was liked by 18 viewers. Enjoy your viewing!
