Set Analysis with rank and filter

[samp]

I am trying to add filter along with rank as below seems syntax is correct but I am not getting expected results any help?

Count({<[Investment Strategy] = {"=Rank(Count({<Type = {'RFI','Database Search','Database Search Follow-Up'},Quarter={'Q1','Q2','Q3'},Year={""$(=Max(Year))""}>} [Investment Strategy]))<11" } > } [Investment Strategy])

[sunny_talwar]

dashes? Can you show a screenshot?

[samp]

returning 0,-1 if I remove one double quote

[samp]

[samp]

my main requirement is I have to show top 10 Strategies who has more count, and corresponding consultants who has more count.

there is another post regarding same Top Customer vs Top Products

[sunny_talwar]

If this is what you are getting after removing one of the double quotes, then I don't see what the issue might be

[samp]

Hi Sunny,

it is working if add filters both places as below:

working fine:

Count({<[Investment Strategy]={"=Rank(Count({<Type = {'RFI','Database Search','Database Search Follow-Up'},Quarter={'Q1','Q2','Q3'},Year={""$(=Max(Year))""}>} [Investment Strategy]))<11" },Type = {'RFI','Database Search','Database Search Follow-Up'},Quarter={'Q1','Q2','Q3'},Year={"$(=Max(Year))"}>}[Investment Strategy])

I am trying to achieve my final result, only issue is not getting correct data for top 2 customer but ok for top 1 customer.

below adding sample inline data and my correct exp.

OK Dim: product

OK Tot Exp:

count({<product = {"=Rank(count({<Quarter = {'Q1','Q2'}>}product),4)< 4"},  Quarter = {'Q1','Q2'}   >}product)

OK top1 Exp:

count({<product = {"=Rank(count({<Quarter = {'Q1','Q2'}>}product),4)< 4"},  

customer = {"=Rank(Count({<product = {""=Rank(count({<Quarter = {'Q1','Q2'}>}product),4)< 4""},Quarter = {'Q1','Q2'}>} product)) = 1"},

Quarter = {'Q1','Q2'}   >}product)

NOK Top 2 ExP:

count({<product = {"=Rank(count({<Quarter = {'Q1','Q2'}>}product),4)< 4"},  

customer = {"=Rank(Count({<product = {""=Rank(count({<Quarter = {'Q1','Q2'}>}product),4)< 4""},Quarter = {'Q1','Q2'}>} product)) = 2"},

Quarter = {'Q1','Q2'}   >}product)

below is inline:

custTable:
Load * Inline [
customer, product, Quarter

'abc', 'p1', 'Q1'
'abc', 'p1', 'Q1'
'abc',  'p1', 'Q2'
'abc', 'p2', 'Q2'
'abc', 'p3', '44'
'abc', 'p4', 'Q1'

'pqr', 'p1', 'Q2'
'pqr', 'p2', 'Q2'
'pqr', 'p1', 'Q2'
'pqr',  'p2', '44'
'pqr', 'p5', 'Q1'

'xyz', 'p5',  '11'
'xyz', 'p3',  '11'
'xyz', 'p3',  '11'
'xyz', 'p5',  '11'

'xyz', 'p2',  'Q1'
'xyz', 'p6',  'Q1'
'xyz', 'p5',  'Q1'

'EEE', 'p3',  'Q1'
'EEE', 'p3',  'Q1'
'EEE', 'p3',  'Q1'

'DDD', 'p4',  'Q1'

'DDD', 'p3',  'Q1'

];