Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Maybe this
DImension : Aggr ( Count( Distinct InvNo) , Custcode)
Expression : Count( DIstinct Custcode)
jj
Hi
Maybe this
DImension : Aggr ( Count( Distinct InvNo) , Custcode)
Expression : Count( DIstinct Custcode)
jj