1 Reply Latest reply on Jun 21, 2012 10:48 AM by Tracy Rodgers

    Calculations in a single column

      Hi, what im trying to do is divide the different values in a column by the total sum of all the values in a certain area

       

      Tableu.PNG

       

      For example in the secound group of rows i would like to divide 218 by the total sum of that same column (5843) so i can get the % of that amount in that group.

       

      I have been trying the following where Por2 is this:

      lookup(COUNT([Total]), first())/lookup([SumaTotal], first())

       

      im dividing the count of total by the total sum of this counting but all im getting is the sum of the same row.

       

       

      Any ideas on how to do this?

       

      thanks in advance