I have a set of data in which the only locational data is a variable called 'Region'. There are several regions and each region represents several different US States. For example, the 'East' is a region that covers Kentucky, West Virginia, and Pennsylvania.
I also have other variables such as 'Sales', 'Cost', 'Profit', etc, all of which are calculated measures.
I would like to view the measures on the heatmap to see which regions are doing well and which may be underperforming. Is there a way to assign states to regions in some way?