Ravi Dawar
New Member
Fellow members,
My raw data is in the following format (it's a forecast of next four years for different automotive brands across different countries) -
I created a pivot table that looks like this -
Then I created a dashboard that lists all these automakers and the numbers for next four years (after doing some more calculations related to my work).
Now, I want to somehow add a button or some control field in the dashboard for different countries. E.g. If i click USA, I see only USA data (2017-2020), If I click Canada, the pivot table removes the four value fields for USA and add the corresponding fields for Canada and so on and this refreshes my dashboard that is referencing the pivot table fields.
Is there a way to do it? Any help is appreciated.
Thanks.
My raw data is in the following format (it's a forecast of next four years for different automotive brands across different countries) -
I created a pivot table that looks like this -
Then I created a dashboard that lists all these automakers and the numbers for next four years (after doing some more calculations related to my work).
Now, I want to somehow add a button or some control field in the dashboard for different countries. E.g. If i click USA, I see only USA data (2017-2020), If I click Canada, the pivot table removes the four value fields for USA and add the corresponding fields for Canada and so on and this refreshes my dashboard that is referencing the pivot table fields.
Is there a way to do it? Any help is appreciated.
Thanks.