I have a report with product category actnonreg actreg rx under that categories again there are 4 sub divisions with names as act1 act2 act3 act4

Question

Hi,

I have a report with product category actnonreg,actreg,rx,under that categories again there are 4 sub divisions with names as act1,act2,act3,act4,

Now in the slicer in the visualisation has three categories(act nonreg,act reg,rx),when we select act non reg the result should give only few  values not all the values in the actnon reg category.

If anyone knows about this,please help.

Thanks