I am trying to create a dashboard that shows first a table having ‘the Group’ containing: EU,Asia ... and another table contain ‘the name of the countries’: France,Spain... and some YTD KPIs on a scorecard. The Problem is that the YTD of EU is not the sum of SPAIN + France ... but is calculated as a wheigted average. My ultimate Goal is to be able to click on EU and the second table shows me the list of EU countries (France and Spain) and when I select France, the Scorecard shows the YTD of France, If Spain it should Should show the YTD of Spain but if i only click on EU without selecting the country, I want the scorecard to show a specific value and not the sum of France, Spain...
LinkedIn
Twitter
