1 of 1 people found this helpful
The above screenshot is working when I click the multiple bar charts from 2005 to 2017. But I can not understand what kind of data is exactly filtering out? Could you explain.
My end goals is when for example I click the blue bar (250k-499k) within 2017, the drill down action to show me only the 250k-499k accounts based on "category". And same for 500-999k and 1M+.
How is the screenshot that you posted filtering out data. Which is working indeed.
2 of 2 people found this helpful
What I showed in my screenshot is passing the year value as a filter from the AUM sheet to the Data sheet.
It sounds like instead you want to pass the AUM category as a filter? You won't be able to do this with your current data structure. In order for it to work, you need to pass some dimension from sheet A to sheet B that says '250k-499k'. The values need to match exactly in the the different data sources. You should be ale to pivot your data source to get this to work