7 Replies Latest reply on Jan 21, 2020 11:14 AM by Joe Oppelt

    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