Filter the values based on condition

[marishnagendran]

Hi Team,

In Straight Table, I want to show only Profit% column has < 25% value only. (Customer C and D wants to display)

how it is possible

[BrunPierre]

Suppose you have Profit% = (Profit/Cost Price)*100.

Use the below as the calculated dimension and uncheck the option to show null values.

=Aggr(If(Sum(Profit/Cost Price)*100 < 0.25,[Customer Name]),[Customer Name)

[marishnagendran]

We have a formula to derive the Profit % (E.g (365/Column(5)) * Column(6))

So, I want Profit% column has < 25% value only. (Customer C and D wants to display)

using Expression we can achieve this??

[BrunPierre]

Maybe with the use of If() as below.

If(((365/Column(5)) * Column(6)) < 0.25,(365/Column(5)) * Column(6)))

[marishnagendran]

I'm already used this expression,

In Table box, It shows all 4 Customers.

For Customer A and B the Profit% Column indicates NULL value.

But I Need to remove A and B customer from Table Box

[BrunPierre]

What is your expected result? maybe share a snippet.

[marishnagendran]

Source Data

I Need Output Like this

[BrunPierre]

Use this as a calculated dimension thus enabling the option to suppress the null values. Replace the column names with the actual expressions

=Aggr(If((365/Column(5)) * Column(6))< 0.25,[Customer Name]),[Customer Name)