Using count to create a dimension

[Sunil_Kenth]

Hi,

Is it possible to use the 'create calculated dimension' to create a dimension based on my data?  I would like to create a dimension which counts the number of invoices in the selection, i would then expect the x axis to display numbers i.e 1 - 10, and plotted on the y axis the number of customers that have that number of invoices.

The table looks like this:

InvNo. , CustCode, Amt

1, Guar01, 2000.00

2, Field22, 196.48

3, Promo01, 201.55

4, Promo01, 196.45

Thanks,

Sunil

[#2 · Accepted solution]

Hi

Maybe this

DImension :  Aggr (   Count( Distinct InvNo) ,  Custcode)

Expression :  Count( DIstinct  Custcode)

jj