Top N values based on condition in a textbox

[prathipsrinivas]

Hi Experts,

I have a requirement where I need to show a list of N products in a text box .

That is, list of all the products whose sales are less compared to last year, it might be 5 or 10 or random number.

I have tried Firstsortedvalue but as you all know which gives one Product as a Output.

I am stuck on how to proceed further here. 

Any suggestions are most welcome.

Thanks in advance,

Prathip

[prathipsrinivas]

Hi,

I have found a work around by Creating Straight table and limit the Dimensions using the Condition Sum(current year)-sum(previousyear)<0 and hide the expression column in presentation and format in such a way it looks like text box. With this, we can make selections as well.

Please let me know if you have any alternate solutions.

Thanks,

Prathip

[MayilVahanan]

Hi @prathipsrinivas 

Try like below

=Concat(Distinct {<Product={"=Sum(current year)-sum(previousyear)<0"}>}Product, ',')