Hi all, I'm pretty new at this and i'm expecting you to tell me the answer is no, but maybe someone knows a clever work around?
I have a large table and summary power Pivottable... Currently have slicers on the pivot table and would like them to also control the regular table, much in the same way that you can connect a slicer to multiple pivot tables, but I haven't been able to find anything on how to accomplish this... guessing it's not a built in feature?
If the drill down functionality was better i'd just use that after applying my slicer filters to generate the filtered list, but I keep getting the too many filters error...
Does anyone know if it's possible and if so how i can control a pivot table and standard table with a single slicer?
Thanks!
I have a large table and summary power Pivottable... Currently have slicers on the pivot table and would like them to also control the regular table, much in the same way that you can connect a slicer to multiple pivot tables, but I haven't been able to find anything on how to accomplish this... guessing it's not a built in feature?
If the drill down functionality was better i'd just use that after applying my slicer filters to generate the filtered list, but I keep getting the too many filters error...
Does anyone know if it's possible and if so how i can control a pivot table and standard table with a single slicer?
Thanks!