Top N set analysis

[NickHoff]

I have a working set analysis expression that limits the population to the top N.  However, my data model includes CalendarYear, CalendarMonth, and CalendarQuarter, but none of the calendar objects work with top N expression.  How can I get Year, Month, and Quarter to work?

COUNT({<ProcedureSurgeonName = {"=RANK(COUNT(DISTINCT SurgicalCaseSk),4)=1"}>}DISTINCT SurgicalCaseSk)

[#2]

As per the expression (If it is working), Year, Quarter and Month selections should effect the data. So there might be something wrong in your data model.

Can you attach sample QVW and/or explain the set expression, dimensions on the chart etc?

Regards,

KKR

[NickHoff · Accepted solution]

It was correct in the data model my problem was there was an alternate state selected on the calendar fields, which threw everything off.