expression in list box: grouped

[chriscools]

Hello,

what do i  have to do if i want to make an expression in a list box, but is has to sum of values per client.

so what i want to see is not al the values, but only one value (total) per client.

because i have to make it possible for people to search values above a certain free to choose value.

and my idea was to do this with the search function of a list box, and then search on (for example): >2000

can someone help me?

thanx!

[Oleg_Troyansky · Accepted solution]

Use advanced aggregation:

AGGR(sum(Values), ClientID)

[chriscools]

Hey Oleg,

thanx! that was what i needed!

grtz,

chris

[#4]

Hi Oleg,

              I check with your above expression its working but it is showing the particular client value & also the total value, but  i do not want to show the total value in list box , i just want to show the particular clientID total only not whole total.

Hope you understood.

Regards,

Antony.

[#5]

Hi Antony,

What my understanding from your post is

You want to dispaly only one clientid total in another listbox if you select particular clientid from another listbox

if it is right then, try this expression

=If(GetSelectedCount(ClientID)>0,AGGR(sum(Values),ClientID))

Let me know what i thought is correct or not!!!

Regards..

[#6]

Hi Ravi,

Thanks for your reply..

Its showing when click that clientID, how do i show particular clientID total without selecting.

Regards,

Antony.

[#7]

If you want to show the total values of a Client ID inside the same listbox you can simply add the formula aggr(sum(Values),ClientID)