1 Reply Latest reply: Feb 25, 2013 3:05 AM by Jonathan Brough RSS

    Conditional Dimension Exclusion

      Good time of the day to you.

       

      In my application, I have a Comp Status field that has values 'Comp', and 'Non-Comp'. Underlying data has two corresponding columns. One - "Comp Status", another - "Next Year Comp Status" for last year calculations. Underlying data looks something like this:

       

      Data-Sample.png

       

      In my Straight Table I have two columns for this, and last year. When I select "Comp Status" to be 'Comp' I have to aggregate based on Comp Status for this year (which is done automatically), and on Next Year Comp Status for last year calculation, which I do using set expression.

       

      With this setup Totals are being calculated properly, but when it comes to showing individual locations on rows, location #3 does not appear in the set.

       

      How can I override default behavior to filter dimension based on its Comp Status and instead have it filter on the expression that would take Next Year Comp Status into the same consideration?

       

      Please let me know if my question needs more clarification. Thank you for your attention!