1 Reply Latest reply: Sep 26, 2011 7:18 PM by Nagaian Krishnamoorthy RSS

    Filtering with a groups dimension



      I haven't been able to find any answers to this question, so I'm hoping I'm not repeating an existing discussion, but here goes!


      I have a chart that displays a grouped dimension (city, state, country) and a metric.  There is an unknown value in each one of these dimensions, but that unknown value is different for each one - Unknown City and Unknown State.  I'd like to filter out the unknowns when the group dimension is cycled to city or state because it's the dimension with the largest number of rows, and skews the look of the graph.  However, I don't want that filtering to affect the other dimensions.


      Essentially, what I'm looking for is conditional filtering of the dimension, based on the group dimension I'm currently showing.  Any advice?  Thanks!