Listbox that shows all the sales of a client depending on registered date

[Anonymous]

Hello,

I have a doubt and i hope that you can help me.

I have been asked if it possible to have a listbox that depending on the date it will show all the sales for the clients that were registered or dropped that date.

the registered and dropped date is shown in two fields, where when it is 1 it shows when it was registered or dropped.

I would like to have a listbox that it does what i described above, selecting a date it will show me all the clients sales for all months if the clients was dropped or registered.

i attached you a qwd with some of my data.

hoping you can help me.

thank you

[tresesco]

Try list box expression something like:

=Aggr(Sum({<Registration={1}>+<Drop={1}>}Sales),Date,CLIENT)