Expressions in Fixed Number Limitations?

[#1]

Hi,

I'd like to have the fixed number limitation display the bottom 20 results where "UnitsSold" <> 0.

Unchecking "Include Zero Values" makes it return no results at the moment.

Is this possible using expressions?

Thanks,

Keiran

[vkish16161]

Can you please explain what your requirement is more clearly with example?

[#3]

Here is an example table:

ItemCode	ItemPrice	UnitsSold	TotalValue
A1	£1	0	£0
A2	£2	1	£2
A3	£5	10	£50

"ItemCode" currently has a fixed number limitation calculated on "UnitsSold" to the bottom twenty. We would like to filter out any results where UnitsSold = 0.

[shraddha_g]

Share screenshot of expression you used and output you are getting without unchecking "Include Zero Value".

[vkish16161]

Based on what I understood, you could try this.

IN A TEXT BOX,

Concat({<UnitsSold={0}>}ItemCode,',')

This will give you a list of ItemCodes where UnitsSold = 0

If this doesn't work you can try:

Concat (

Aggr (

if(Sum(UnitsSold) =0,ItemCode )

, ItemCode )

, ',')