PDA

View Full Version : Drill Down Pivot Same Page



tbarnett
07-11-2016, 09:10 AM
I'm using a Pivot Table to collect a large number of text comments that have been classified according to category, date, etc. While counts of categories are the main use of the table, I'd like to be able to drill down while still in the same table, instead of opening into different pages. This is a report that I'd like to send to users of varying skill levels, so I want to make it as simple as possible for them to use.

If possible, I'd only to include the column that is named "Customer Comment" I don't need all the other data in the record, just the one cell in each row.

(My company is still using office 2010, so I know there are other updates in-program since then, that may partially address this issue.)

Does anyone have any suggestions on a macro-driven way to accomplish this goal?


Thank you!