Set Analysis with modifier

[Anonymous]

I have the following calculated dimension:

i need to add the following set modifier to the expression:

[New Product Indicator] = 'YES'

How can the above calculated dimension be modified to accommodate the above?

Regards.

[sunny_talwar · Accepted solution]

May be this:

=Aggr(If(Rank(Sum({<[New Product Indicator] = {'YES'}>} Amount)) <= 20, [Drug Name]), [Drug Name])

[Anonymous]

Thanks Sunny