14 Replies Latest reply: Sep 24, 2015 3:17 AM by Paul Steinborn RSS

    Sum over aggr (in text object)

    Paul Steinborn

      Dear Community,

       

      i have a straight table with one dimension 'Group' and one expression '=SUM(Aggr(SUM(AMOUNT),GROUP))'

      On the top are the totals by expression

      The result looks like this :

      1.png

      Now i want to display the total 49398... directly inside a text object as a key performance indicator using the same expression

      =SUM(Aggr(SUM(AMOUNT),GROUP)). But its not working as the number is not the same comparing with the straight table total


      What i am making wrong? Please help