Create a table having built in condition.

[#1]

I have a table having the columns Name, Department , Salary and sex.

I want to build and show a table for all male employees. The table should have name, department and salary and should display only values where sex='m' by default.

Any help would be appreciated. Thanks

[Gysbert_Wassenaar]

Create a straight table with name and department as dimensions and as expression sum({<sex={'m'}>}salary). Make sure to use the correct case sensitive field names.

[#3]

Thank you the reply Gysbert. I figured that out. I am however looking for a way to show it without any expression which kinda rules the straight table out.

[bgerchikov]

Hi Ravi,

You need this condition somewhere in the chart or another option is to set a trigger on opening to assign "m" to field sex.

In chart you can set this condition in expression set analysis or in dimension:

if(sex='m', Dimension_Field,null())

Hope it will help

[Colin-Albert]

If you want to do it without an expression, then add a listbox for the field sex alongside your chart.

Click on m and your chart will show the data for males.

[Gysbert_Wassenaar]

Ok, try alternates states then. Create a new alternate state. Create your table box. Assign the table box to the new alternate state. Select the value 'm'. Right click the column and choose Lock.