5 Replies Latest reply on Jul 11, 2017 12:54 AM by Sravan Yadav

    Changing level of detail on Heat Map

    Oh Benjamin

      Hi All,

       

      I have been reading up multiple posts on this problem I am facing but cannot seem to find a solution.

       

      I have a heat map of data categorized into Regions, and Country specific. The intention is to create a visualisation of a heat map to show Real GDP over the years.

       

      I notice that I am able to change the categorization from Region to Country my map will adjust accordingly. However, the is inaccurate as for Region the Real GDP should be average (Region specific) and for country the Real GDP should be Sum.

       

      I was also wondering if a filter could be created so that the users, with a click of the button, is able to switch between Region and Country view easily.

       

      I have attached by workbook and look forward to your professional help!!!

       

      Thank you in advance.