I have my data across 7 sheets and all are linked with feild name ID. When I create dash board , it's have 6 filters. I would need only one filter at dash board. I have applied filter with applicable to all sheets with the source used/all sheets but It didn't help me.
Ffor example : table a : ID and name
table b ID project name
table c ID risk
table D ID help.
table E ID delivery date
now i am getting 4 filters when I join the tables and publish the dash board.
I want to publish the dash board with project name as unique filter.