Showing the Higher Selected Field from the Hierarchical Group
I have a line chart where my X dimension is a Hierarchical Group zone. Inside a zone I have a neighbourhood for every zone and so on.
Then I have my Y dimension where I have a quantity of different tasks for every zone / neighbourhood / etc. See figure 1.
If I select a zone then I get the quantity for every neighbourhood. See figure 2.
The thing is: If now I only select 4 or 5 neighbourhoods (the 2nd level from the hierarchical group) from different zones without selecting any zones, I would see the chart shows me the higher hierarchy (zone 1, zone 2, zone 3) with the associated neighbourhoods inside the zones (See figure 3), and I would like to see each neighbourhood directly...
In brief, I'd need to show the HIGHER SELECTED FIELD from the hierarchical group in the X dimension.
Would that be possible? Maybe for example using set analysis inside the bar chart?
