I am stuck in a weird situation where I have find a solution that should resolved my requirement in a different way but need your inputs.
Actual Issue:Need to show higher level details with lower granular filter applied on the same source.
I want to action filter on Channel from a different widget to show that only own channel (whichever channel I select) and group of channels of competitor of same Genre (of the same channel I selected in Action filter)
Please find the example below:
Solution I Could figure out:
I have duplicated the same data source to distribute the data on the basis of own/competitor. Then I am trying to apply different action filter on both data sources.
Source 1 - Channel
Source 2 - Genre
Above solution is possible when I create two widgets and put it on swap in the same container. I want the result in the same widget. Let me know if there is a way to achieve this.
Please supply a Packaged Workbook to assist the community with helping on this question. It will help a great deal to share a bit of sample data to show what you have tried and the sort of data being considered.