Hello,
I've been searching for a solution but so far found nothing. Say I have a pivot table that has hundreds of values in the value field. what I need (not sure at all if this is doable) is to be able to select some of the values and the codes will drill down on these values only and show the details (stacked in the order of the values) on a new sheet. I know this is probably too much to ask, but if someone out there can make this happen, that would be truly amazing!
thanks for your time.
Last edited by lynnsong986; 10-20-2019 at 12:54 AM.
I don't have experience with them but perhaps slicers would help?
Thanks for replying. I need the underlying data for reconciliation purpose though, slicers won’t help...Originally Posted by Pepe Le Mokko
I'm doing this using a work-around, I used autofilter on multiple columns and put those lists as arrays, it worked. maybe drill down directly like that is not dorable then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks