set analysis on selection

[doespirito]

Hello,

I try to create a selection field with set analysis.

in this example (see qw attached), the graph shows sales from junuary to the selected month with set analyssis..

We can see dupont and durand in the graph.

But in the selection field member, we only see durand.

Can i have dupond and durand in the selection field?

And how can i do that ?

Thank you very much for your help,

Arnault

[effinty2112]

Hi,

In the member listbox dupont is in grey for a very good reason. You have selected year = 2017 and month = 8 and dupont is not associated with these selections and so is grey. You can still select dupont when it's grey but you will lose your selection month = 8.

Regards

Andrew

[doespirito]

Thank you for your response,

i know why dupont is grey but i would like to create a selection box with all people who have made sales from january to selected month.

and not only in august, as in the chart.

[sunny_talwar · Accepted solution]

May be use The As-Of Table

[doespirito]

wonderfull !!

exactly what i wanded