9 Replies Latest reply on Jan 14, 2017 2:28 PM by Norbert Maijoor

    Sum of Specific Dimension / Sum of Another

    Eoghan Lyons

      Hi all,

       

      I'm having a spot of bother with a calculated field.

       

      I have a list of factors lined up in one column.

       

      What I'm looking to do is to divide the sum values where the factor is "number of transactions" by the sum values where the factor is "visitors".

       

      Something along the lines of

       

      sum(if [Factor]="Number of Transactions" then [Number of Records] end)

      /

      sum(if [Factor]="Visitors" then [Number of Records] end)

       

      Except I want to sum the values rather than the number of records. Is this possible?

       

      Many thanks,

      Eoghan.