Need to show top 20 values in straight/Pivot table

[#1]

Hi Team,

Have a requirement that, need to show Top 20 Traveller names based on highest spend on YTD basis.

Our financial year starts from October to September.

For eg., If the user selects the month Nov, we need to show the Top 20 Travellers who spend highest for October , November months respectively.

Same way if the user selects the month Jan, we need to show the Top 20 Travellers who spend highest for October, November, December and January months respectively.

Currently we are getting Top 20 only for selected month.

Thanks,

Pani

,

[MK_QSL]

Provide the expression you are using currently !

[#3]

HI Manish,

Please find below my exp

SUM({<FiscalYear=,MonthShortName=,FiscalMonthKey={"$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd))"},Traveler_name11 = {"=Rank(Sum({<FiscalYear=,MonthShortName=,FiscalMonthKey={""$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd))""}>}[nvcrTxthotcost]))<21"}>}nvcrTxthotcost)

variables Point:

vSelYrMthStart: Fisical year month start (Jan 16)

vSelYrMthEnd: Fisciacal Year Selected Month (May 16)