Create a Dimension Based On Top Customer.

[infosense_devel]

Hello,

I have customer name as dimension and expression to calculate their invoice.

I want show top customer category wise something like this,

In top 10 invoice showing for 1-10 Customer and so On and also want display count of customer.

[MK_QSL]

Use combination of

Aggr, Rank, If, SUM(Sales) to create Calculated Dimension...

You can also use ValueList Function and use Expressions accordingly..

Better if you provide sample data to work along with the expected results based on sample data.

[antoniotiman]

Hi,

Try Calculated Dimension

=Aggr(Class(Rank(Sum(Invoice),4),10),Customer)

[infosense_devel]

And for Expression Side?

[antoniotiman]

Sum(Invoice)