Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

problem with count

Dear all,

I'm a bit confused. I've a Customer Masterdata table. I 've to produce a simple graph like this:

Total customer 2000

Customer from CRM   500  25%

Pending customers    100    5%

Customer without Sales orders  200  10%

and so on..

How can I do it ?

Thanks in advance for your help

2 Replies
Not applicable
Author

Hi,

If you use the straigth table, add two expression.

Ex.:

QTY:

COUNT(CUSTUMER)

% QTY:

COUNT(CUSTUMER) / COUNT(TOTAL CUSTUMER)

jfkinspari
Partner - Specialist
Partner - Specialist

For the second espression you can also just tick the 'relative' box, and use the same formula as from expression 1.