show total Sales in a text box without effects from selection

[alec1982]

Hi,

How can i show up total sales in a text box without getting effected by the selection made by user?

So no matter what the user will filter by i need this text box to show total sales.

Thxs

[swuehl · Accepted solution]

Use a set expression with set identifier 1 for this:

=sum( {1} Sales)

Regards,

Stefan

[alec1982]

Thxs

Cheers!