Filtering dimension based on object selection button
Hi, I have a dimension as STATUS which includes different fields like opened, cancelled,......etc . I created one text object I see it as a button. Whenever I click button the table should show all the record including (cancelled) and again when I click button it should show all the record except (cancelled). How can I do that?