For example if I had a list of everyone that was resident in Australia and that list included the following fields:
Location by state, age, male/female, firstname, lastname.
Using that data create a pie chart that can be drilled down through the following levels:
percentage by state, age and finally male/female.
When using the first level of percentage by state you control clicked on a segment of the pie chart and it then showed a modal table that is a filtered list/table by the selected location for all the remaining information. The table would be searchable. When you close the table you go back to the first level of the pie chart, Same same for the second level which would be a state with segments for male and female. Control click on one of the two segments and it brings up the underlying data.
I hope that is clear enough and thank you for responding.