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

    Swapping with Multiple Conditions

    Vasu choudhury



      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 



      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.