5 Replies Latest reply: May 25, 2015 8:57 PM by Yun Zheng Soh RSS

    How to create a filter based on 2 dimensions

      Hi,

       

      I would like to filter my data and display them by creating a filter based on 2 dimensions. Let's say I have a data set with 2 fields, Status1 and Status2. I would want to show any data that has "Urgent " in either Status1 or Status2, how do i do that? Status1 has 6 entires with urgent while Status2 has 7 entries with urgent. There are a total of 5 overlapping ones (meaning both Status1 and Status2 are urgent). Therefore the total number of urgent cases should be shown as 8, but right now, I can only make it display 6 or 7 depending on which Status I use as the dimension.