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