Top 5 in pivot

[#1]

Hi all,

  i want to show top 5 customers in pivot table.how can i get this in pivot

PFA

[MK_QSL · Accepted solution]

Create a pivot table

dimension

customer

Expression

SUM({<customer = {"=Rank(SUM(cost),4)<=5"}>}cost)

[israrkhan]

as Manish said, it will work...

or use Straight table, and use dimension limits tab, select top 5...