2 Replies Latest reply on Nov 14, 2018 2:25 PM by Mark Vee

    Filtering Numerator and Denominator Differently

    Mark Vee

      Hello All,

       

      I know there a couple other posts addressing filtering two parts of a calculated field. Yet, I still can't resolve my particular issues. I would imagine it would be done via LOD calculations and I would have to use "Fixed" because in the order of operations it come before a dimension filter. My other option I thought that might work is using parameter with an if statement. However, I think that would negate the multiple selections or all selections options. I've also attached a packaged workbook.

       

      So the issue is I want to filter the numerator with all four filters and I want to filter the denominator only three bottom filters (excluding Ship Mode). Is this possible?

       

       

       

       

      . Numer & Denom Issue.png

      Regards