1 Reply Latest reply: Jul 31, 2013 3:12 PM by Mayil Vahanan Ramasamy RSS

    How to ignore selections in specific fields in a straight table ?

      I am trying to use set analysis to ignore selectings within specific fields in my data within a chart straight table.  I understand how i can utilize set analysis and calculated dimensions to apply filters automatically, so I am trying to apply a similar concept to ignore selections instead.  Also, I am aware of the Detach feature, but I only want to ignore certain (not all) field selections.


      For example:  Suppose I have a table:





      Now suppose I have made a selection in Dim1 (say I selected value B).  If i set up a straight table with the expression Sum(Value) and dimension Dim1, i will see

      an output of 1 row. 


      I want to be able to see all rows, since I would be ignoring the filter I made in Dim1.  


      Any Ideas?