I have a question with respect to creating filters for a table chart. I had asked a question for the same table chart visualization previously. I am attaching the chart again. It has many other columns along with this one.
Is it possible to create a filter that will have only 2 values as 'Policy' and 'Discount' based on the 'Type' column, but it should display all the rows containing the respective text?
To elaborate, say the filter is set to 'Policy', then I want the result to be like: