Hi there, here is my second challenge of the day.... being a relative freshman in Sense.
I need a barchart of customers with a total turnover over 50k, 20-50k and 0-20k. The bar should show total turnover in that categorie and I would also like to show the number of customers that build up the total revenue.
The categories are made with a valuelist, but how can I get the aggregate for each categorie and the count of customers in it??
the count(distinct) wil then replace the sum(turnover) ? But that is not what I meant... I would like to plot the turnover AND at the same time I would like to show just the count(distinct customers) that build that particular turnover total.