I have a hierarchy which contains States -> Regions -> Cities. I want to create 1 bar chart which shows the sum for the selected city, the sum for the region where the city belongs to and the last bar should show the total for the state.
I also have a chart which only consists off the cities. But they are selected in 2 different listboxes with 2 different states. In the first listbox with state 1 I selected 1 city which I want to compare with 3 cities which are selected in the listbox with state 2.
I want to make a line chart which show the 4 cities compared to each other over a couple of years.