Excel 2013: Show slicers based on a certan selection on a pivot table -
is possible display slicer based on selection on field in pivot table?
i have large number of fields two-layer hierarchy, let's have level 1 hierarchy values a
, b
, c
(yes/no option only) , second level fields a1
, a2
, a3
, b1
, b2
, b3
, etc. have built pivot table adding filters a, b
, c
. if add second level number of fields displayed on pivot large, i'd display slicers based on selection. example, if value in field a
yee
, display slicers a1
, a2
, a3
.
is possible?
Comments
Post a Comment