Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
Try Calculated Dimension
=Aggr(Class(Rank(Sum(Invoice),4),10),Customer)
And for Expression Side?
Sum(Invoice)