5 Replies Latest reply: Aug 17, 2016 1:33 AM by Shivam Sarin RSS

    How do I calculate the ratio of a sum total by each number of rows.


      I want to get the ratio of total Store Sales ie 15.32M by each store sales. How can I get this division?

      I tried putting the total Sales in a variable and then divided by using aggr function: Aggr(Sum(UNITS),STR_ACCOUNT_NAME_DESC).

      I'm not getting the correct answer. I need it 15.32M/ Sales of store 1,Store 2 and so on in the table