1 Reply Latest reply on Apr 22, 2016 8:51 AM by Christian Berg

    OBIEE Analysis Query

    Adz10

      Hi,

       

      I am trying to produce a table like this in OBIEE Answers. I am able to get product and sold column fine but how can I work out the % column.

       

      It is basically doing % = product_sold/total * 100

         

      ProductSold%
      A5055.56
      B2527.78
      C1011.11
      D55.56
      Total90

       

      Thanks