4 Replies Latest reply: Apr 23, 2012 5:57 PM by bkhoward2001 RSS

    Basic question about dimension and total across aggregation

      I have a simple table chart that groups a count by category such as:

       

      Category A                      10

      Category B                       15

      Category C                       12

       

       

      Category is the dimension as say count(people) is the expression.....

       

      I want a column that has the percent of total so that it looks like:

       

      Category A                      10          27.03             

      Ctegory B                       15            40.54

      Category C                       12          32.43

       

      How would the expression look so that you could get the total across the dimensions so you can divide by it? Thanks.