i have one requirement we have 2 sheets first sheet data contains 3 parameter values 1) department 2) segment 3)product .. second sheet contains only departments.
we create two dashboards . First dash board contains sheet1 second dashboard contain sheet2. we created a menu action filter on sheet1. my requirement is if i select depart in sheet1 parameter then only menu filter action will visible for navigation. if i select other values that menu action item will be not visible .. how can we solve this?