Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear,
I know it's possible to make a graph where you select only the top 15 of customers for example,
but can someone tell me if it's also possible to make a table (pivottable) where I only want to see the top 15 customers with theie sales figures for a couple of months, and how I can make this?
thanks in advance
Hello,
Assuming you have a "CustomerID" as field and figures of sales are recorded in "Amount" field, I would do a calculated dimension something like
=If(aggr(rank(aggr(sum(Amount), ID), 4, 2), CustomerID) <= 15, CustomerID)
Then check "Suppress null values" for that dimension, then use
as expression.Sum(Amount)
Hope that helps!
Hello,
Assuming you have a "CustomerID" as field and figures of sales are recorded in "Amount" field, I would do a calculated dimension something like
=If(aggr(rank(aggr(sum(Amount), ID), 4, 2), CustomerID) <= 15, CustomerID)
Then check "Suppress null values" for that dimension, then use
as expression.Sum(Amount)
Hope that helps!
Works perfect!
Thanks