How to change Pivot table value fields from a dashboard?

[Ravi Dawar]

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.

 

[Chihiro]

Your raw data isn't in ideal format for PivotTable.

If you have access to PowerQuery, I'd first unpivot the table and add calculated column(s) to identify each line item with Country etc.

To get better help from members. I'd recommend uploading sanitized data that mirrors your raw data set up.