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:
• GROUPBY Function The Basics and Beyond
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