Set Analysis including all but selected field

[zagzebski]

(1) What function do I use in an expression to get the total of everything EXCEPT the selected field?

For instance if I simply wanted to sum revenue but for all clients except the one I have selected what is the set analysis for that?

(2) Similarily to this if  I have a client that is part of heirachy, how do I get the total of the heirachy for the client chosen?

Example Client A is part of the Auto Division, Client B is part of the Home Division, etc

When I select Client A how to I get the total revenue for the Auto Division? then if I select client B I get the total revenue of the Home Division?

Thanks in advance...

[#2]

Hi,

Try with this:

Only({< Dim={'*'}-{$(=GetFieldSelections(Dim))} >} Dim).

See the attached.

Regards,

Ricardo

[zagzebski]

Thanks for the assistance.

Here is what I have in my expression but nothing is coming back...

sum(Only({< [Product-Entity]={'*'}-{$(=GetFieldSelections(Product-Entity))} >} [Product-Entity]),[Revenue])

[Anonymous]

Try using E(), which means "Excluded":

sum({<Product-Entity]=E([Product-Entity])>} Revenue)

Regards,

Michael

[zagzebski]

Thanks!

Is it possible to do this:

If  I have a client that is part of heirachy, how do I get the total of the heirachy for the client chosen?

Example Client A is part of the Auto Division, Client B is part of the Home Division, etc

When I select Client A how to I get the total revenue for the Auto Division? then if I select client B I get the total revenue of the Home Division?

Is this possible?

[Anonymous · Accepted solution]

Everything's possible 🙂

Try this:

sum({<Client=, Division=P(Division)>} Revenue)

[zagzebski]

Perfect - thanks Michael.