1 Reply Latest reply on Mar 29, 2018 7:40 AM by Soham Wadekar

    Cascading Filters issue

    venkat.ram.1

      Hello Folks,

       

      Attached excel file and Twbx file for reference.

       

      Problem:

      Data:

       

      GroupNameValue
      AA100
      AB20
      AC30
      AD50
      AE130
      AF20
      AG30
      AH304
      AI30
      BA34
      BB67
      BC32
      BD45
      BE67

       

       

      I used filter as Group like below

       

      group=A has 9 records

      When I filter group=A then I need to exclude Name=A in the filter list like below

       

      After Excluding A in the Name, I got 8 records. This is what i'm expecting as a results.

       

      Can anyone please suggest me the best way to filter based on condition.

       

      Thanks in advance.