A Slicer For The GROUPBY Function

A great advantage in Pivot Tables is the ability to use a Slicer which is a graphic interactive filter that makes our Pivot Tables super dynamic. Although a GROUPBY function can do most of the job of a Pivot Table, it is missing the Slicer functionality.
In a previous tutorial, I explained all the mandatory and Optional arguments for the GROUPBY function. Here is the link for this tutorial:

In this tutorial I show you how to create a Slicer that interacts with a GROUPBY function taking the functionality to the next level.
So, let’s dive in

[IvanCortinas_ES]

Excellent interactivity. Many important advances are being made with these GROUPBY and PIVOTBY functions that allow many use cases to be solved. Thanks for sharing, Nabil.

[tamersalem]

رائع جدا وشكرا على نشر العلم والمعرفة تحياتي لشخصكم المحترم ا.دكتور نبيل مراد❤

[nadermounir]

This is a brilliant video. Thank you Nabil :):):)

[JoseAntonioMorato]

Dear Nabil,
Slicing for the GROUPBY or PIVOTBY function can also be done by replacing the SUBTOTAL function with the AGGREGATE function:
from SUBTOTAL(103;x) to AGGREGATE(3;5;x)
And the MAP function can also be replaced by the BYROW function. 🤗

[shoppersdream]

Group by Function is not available on Mac. Thanks