1 of 1 people found this helpful
And how are your tables and relationships set up?
Do you have a customer table linked to either a table of activities or to a join table that is in turn linked to a table of activities?
If so, you can do this, but not easily from the customer table. It's much simpler to do from a table based on the related table either activities (if no join table) or the Join table.
To chart from customers will require extra effort--such as using ExecuteSQL to produce the subtotals as a list of delimited values for a delimited value chart.
Thanks for reply. I was doing this from the customer table yes, and experimented with the data source tab in the chart dialog, and I managed to do this with a count field from a related data source