10 Replies Latest reply: Sep 22, 2016 4:13 PM by Sunny Talwar RSS

    Syntax - Share % Calc using Direct Discovery with Oracle DB

      Direct Discovery

       

      Oracle DB

       

      How do you get the denominator of the share % calc to ignore Product dimension.

       

      Sales Measure:

         

      SalesTime
      ProductMayJune
      A1030
      B1520
      C1321
      D1932
      E1854
      Total75157

       

      Desired output (Denominator for Share Calc):

       

      SalesTime
      ProductMayJune
      A75157
      B75157
      C75157
      D75157
      E75157

       

      How do you get this in an expression.

       

      AGGR(SUM(Sales),TIME) is giving the desired number but it displays only under one Product. As in, I get the below output:

       

      SalesTime
      ProductMayJune
      A75157
      B--
      C--
      D--
      E--

       

      What is the syntax to ignore Product and get the desired output?

       

      Thanks in advance.