This content has been marked as final. Show 2 replies
I have some challenges in implementing the below complex functionality in one dashboard.. Can you please help me out with the below issue.
Filters: State, City, Customer Name & Year.
By default (All) will be selected for the above filters and below results should be displayed
Blue bar should be grouped or displayed at Region level & Year only and should not change with State/City/customer name filters.
Sheet1 - IF Type=High then M1/M2 should be displayed at ID level.
IF Customer Name='Rick' then Type in ("Low", "Below") should be passed as filter condition to the result set along with the region level data.
When Customer Name=(All) is selected then Sheet1 should be displayed, when Customer name=Rick/Jim then Sheet 2 should be displayed.
Attached workbook in 10.5 for your reference.