1 Reply Latest reply: May 4, 2016 2:55 AM by Robert Hutchings RSS

    How to drill through to details in a Pivot Table

    Ajay Gupta

      Hi ,

      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.

      Thanks

      Aj