Filter fields in Straight Table

[achitreskyitgroup]

Hello Guys,

In the adjoining straight table, I need to filter data for all the values in column F which are negative or 0. Is there a way by which I can remove the whole row associated with negative column F?

Column F is a calculated expression ($vSales). I only need rows with sales > 0 populating in the table.

[Kushal_Chawda]

You can use calculated dimension like below

=aggr(if($(vSales)>0,$(vSales),null()),Dimension1)

where Dimension1 is first dimension of your table.

then check "supress null value" option for that dimension

[achitreskyitgroup]

Hey, thanks Kush but it doesn't work

[Kushal_Chawda · Accepted solution]

sorry my bad. try below calculated dimension for first dimension of straight table

=aggr(if($(vSales)>0,Dimension1,null()),Dimension1,Dimension2,Dimension3)

where Dimension1,Dimension2,Dimension3 are straight table dimensions. You need to include all dimensions in aggr.

Another option: You can put sales>0 condition in all expression of straight table and check "suppress zero value" option in presentation tab of chart properties

Assuming your first expression of straight table is for Sales

Expression1: if($(vSales)>0,$(vSales),0)

Expression2: if($(vSales)>0,ActualSecondExpression,0)

Expression3: if($(vSales)>0,ActualThirdExpression,0)

Expression4: if($(vSales)>0,ActualFourthExpression,0)