Table with Top15 Selection

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

Sum(Amount)

as expression.

Hope that helps!

[#3]

Works perfect!

Thanks