Records excluden in chart

[jack]

I have a listbox with  4 choices  in field Website ,  that wil give if all clicked   B ,  I, X,  F   wich are the  KEY-field  in database

chart will show if 1 or 2 or 4 are clicked with  right information  

but if none is clicked,     it will show the records wich not needed in this chart  with  KEY  'O'   in database

instead of leaving chart empty

what to do  in chart key field connected to list box  wich has now:       ='Sales  ' & Concat(distinct [Website], ', ')

[Aurelien_Martinez · Accepted solution]

Hi,

You can use a Calculation Condition in your chart like :

GetSelectedCount(Website) >= 1

[jack]

,   it did only work if i set in all colums ,, don't know if there is smarter way, but anyway it works

Thank you for advice , regards Jack