3 Replies Latest reply on Jan 24, 2019 8:31 PM by Thomas Dodds

    In OBIEE, is it possible to maintain Denominator regardless of the Filters applied?


      Hi All,


      We have a requirement where Numerator of a Column has to be Filtered by the Prompt Values butnot the Denominator.

      Whenever a Product is selected in the Prompt from the List of Products , then the Column Logic will be  ---> Selected Product /Sum(All the Products)

      As of now, whenever i select a Product from the Prompt, Column Logic is changed to Selected Product/Selected Product but i dont want the Filter to be passed to the Denominator.

      I have applied the above column logic in a Union Report Result Column, so there are multiple limitations for me to restrict the Filter values passed to the Denominator.

      Please help me in resolving the above issue.