excel - Filter power pivot using selections from another pivot table -

excel - Filter power pivot using selections from another pivot table -

i created powerfulness pivot (kpi-1) 3 working slicers. instead of slicers, i'd prefer filter kpi-1 using selection powerfulness pivot (pharmacies) within same workbook.

i created sec powerfulness pivot (kpi-2) without slicers on new sheet in same workbook, , created slicer connections first powerfulness pivot (kpi-1). can utilize slicers kpi-1 filter kpi-2.

is there way straight filter powerfulness pivot based on selection powerfulness pivot table, or there way pass selection powerfulness pivot pharmacies kpi-1's slicers, filter slicerless kpi-2? hide kpi-1.

excel vba powerpivot