I have a requirement where I have to show the summary level data and then show the details ?
Here are the details of the requirements . In below example I am showing count of postcodes at the intersection of two dimensions in a Pivot Table. If the user click on any cell ( as circled from the blue pen ), I have to show corresponding postcode values . How can I do that ? Post code values are something like this 2000 2009 2010 2011 2015 2016 2018 2019 2020 2021 . So in the first column if user clicks on 110 , user should see those 110 postcode either in a map or in a separate table. Please let me know if anyone knows about this .
I will really appreciate it.
The ways I have done this is to
Get the user to click on the two dimensions (not the number) and then either depending on circumstances