topic Re: Filter the values on a table in App Development

Filter the values on a table

Tenuki — Wed, 08 Oct 2025 12:00:06 GMT

Hello,

I have create a top 5 items by % margin.

I get this result :

Item %Marg Revenue2025 Revenue2024

Item 1 1050 % 1050 1

Item 2 300 % 9 3

...
I would like to filter revenue, in order to display the top 5 items witch have a revenue2 > 1500 for instance.

I try data manipulation but it didn't work.

My revenue mesure look like this :

sum({<YearRevenue={$(=Num(YEAR(Today())))}>} Revenue)

Many thanks for your help

robert_mika — Wed, 08 Oct 2025 15:00:26 GMT

You can define your values in script and then use as dimension

LET vCurrentYear = Year(Today());

RevenueTable:
LOAD
*,
IF(YearRevenue = $(vCurrentYear), Revenue, 0) AS RevenueThisYear
FROM [YourDataSource];

AggregatedRevenue:
LOAD
Sum(RevenueThisYear) AS TotalRevenueThisYear
RESIDENT RevenueTable;

The add to your main table with a join

Tenuki — Thu, 09 Oct 2025 09:27:53 GMT

Many thanks !