In the previous recipe, we saw that we can filter the whole report by a member or member set using Slicer. This recipe will show you how to add a prompt into Slicer to make it dynamic.
We will use the report that we created in the previous recipe for this recipe. We will need to remove Golf Equipment used in the previous recipe from Slicer.
In this recipe we will see how to add a prompt into Slicer, as follows:
[sales_and_marketing].[Products].[Products].[Product line]->?pProductLine? ...