Firstsortedvalue (Grand Total) issue

[Anonymous]

Hi Guys,

How do I sum the resultant of this expression to display in a textbox?

=FirstSortedValue(Aggr(Sum(FIELDNAME1),FIELDNAME2), -FIELDNAME2).

Thanks

[tresesco]

May be this?

=Sum( Total FirstSortedValue(Aggr(Sum(FIELDNAME1),FIELDNAME2), -FIELDNAME2))

[sunny_talwar]

Will that work without the Aggr() Tresesco?

[sunny_talwar]

Shouldn't it be this

=Sum(Aggr(FirstSortedValue(Aggr(Sum(FIELDNAME1),FIELDNAME2), -FIELDNAME2), FIELDNAME2))

[tresesco]

It should, because TOTAL is there.

[sunny_talwar]

I did not know that by using TOTAL you can avoid using an Aggr. I will try to test this out. Thanks

[Anonymous]

Tried something quite similar "Nested aggregation"

[Anonymous]

That expression return "0"

[sunny_talwar]

For some reason, it did not work for me

[sunny_talwar]

Would you be able to share an image of the chart where you are using this?