List box: how to use a chart expression as a field?

[#1]

Hi,

I have several expression in a chart, each which calculates whether a course is reaching the target on several criteria.  There is an overall count of how many targets are being missed (0 to 6).

How do I create a list box which lists how many targets are being missed (0 to 6)?

Any help, gratefully received.

Regards,

Racine62

[swuehl]

You can use a field expression in your list box (last item on the field drop down opens the expression dialog) with advanced aggregation, like

=aggr( YourChartExpression, YourChartDimension)

Selection in your list box will actually select the underlying chart dimension values then.