0In the following, You would find lesser-known, unexplored yet Powerful Features of Filter.
Please refer to sample dataset below:
To do Data Analysis:
Step 1) Apply Filter on the dataset.
Step 2) In Sales Amount column, click on Filter drop-down.
Step 3) Take Your cursor to Number Filters. A-List of Options will open up.
As highlighted in the screenshot below:
i) Please click on Top 10 - to see list of Top 10 Performers OR Bottom 10 Performers
ii) Please click on Above Average - to see list of Above Average Performers
iii) Please click on Below Average - to see list of Above Average Performers
Likewise, in the Date column, if You click on Filter drop-down, and take the cursor to Date Filters, a List of Options will open up.
As highlighted in the screenshot below, the Options will allow You to do Data Analysis across different periods, in a Click.
Isn't this Cool. Data Analysis in Few Clicks!
