Sum over aggr (in text object)

[Anonymous]

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 :

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

[Anonymous]

See attachement below

[maxgro]

maybe

=sum({$ <Group={"*"}>} Amount)

[Anonymous]

Hi Maxgro,

your solution is not interactive? For example when chossing group A the text object value does not equal with the correct total value of the sraight table. Any idea how to make it possible?

[maxgro · Accepted solution]

maybe this

=sum({$ <Group*={"*"}>} Amount)

[Anonymous]

Best answer till now