Can we define condition in action filter to decide whether to filter another sheet or not?
My use case is like following(Workbook Attached)
One Dashboard Having three worksheets
1) By Product
Gives count of orders for product stacked with “Order number” dimension
Filter Action: On select of any data point filters “By Zone” and “Tabular View” worksheets
2) By Zone
Gives count of orders by Zones stacked with “Order Number” dimension
Filter Action: On select of any data point filters “Tabular View” worksheets only
**I don’t want to use Product as dimension in “By Zone” worksheet to avoid adding more panes.**
3) Tabular View
Shows tabular views of orders
1) When I click any value from product it should filter other worksheets
2) When I further click on any zone (already filtered by Product), it should filter task list for “Selected Product” and “Selected Zone”
I have managed to get this working when I follow above step 1 and then 2 as mentioned above, However when I directly click on “Zone” without filtering by product the task list is **not displayed ** since the “Product Name Detail” value is “All Product”.
You need to edit both actions and use only one field in each, i.e. triggered from Product sheet - use only Product field, triggered from Zone sheet - use only Zone field.