2 Replies Latest reply on Oct 31, 2018 9:12 AM by Shinichiro Murakami

    Swapping with Multiple Conditions

    Vasu choudhury

      Hello,

       

      I have some challenges in implementing the below complex functionality in one dashboard.. Can you please help me out with the below issue.

       

      Sample Data:

      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.

                Calculated from 

       

      Sheet2:

      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.

      calculated from

       

       

      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.