3 Replies Latest reply: Jun 21, 2017 4:27 AM by Sunny Talwar RSS

    Aggregating a sum to different dimensions

    Saez Carlos

      Hello to everybody! This forum has been a great help so far, but I have found a problem that I haven´t been able to solve using the current available knowledge. First of all, thank you for taking time going through my doubt.

       

      What I am trying to achieve is the expression 1 in the image: to sum every count depending on Dim2 but ignoring Dim1, and using it as it is shown below. The count doesn´t appear like that, but comes from the count operation of different IDs

      test.PNG

       

      What I have reached so far, by using this expression =sum( aggr(count({<Dim1>}  distinct ID), Dim2)) throws this strange result:

      test2.PNG

       

      I hope someone can help, and that I will be able to help others in the near future

       

      Kind regards