2 Replies Latest reply on Feb 19, 2019 12:19 PM by Rahul Soni

    Using a group filter change the data display

    Rahul Soni

      So I have this grouped filter that has a drop down in which each value corresponds to multiple values in it. So for eg, if I select a country, it will slice the data and display all the countries with values in each country.

      If I select the Department, it will slice the data and display values for each department.


      here is the screenshot.


      When Total, then this:


      When Department then this:


      So I want to achieve this in the worksheet, so I can add it to the Dashboard. How can I do that? I just want the data to be sliced based on the grouped value selected in the rightmost drop down.