Create an Condition into a Table Box

[Anonymous]

Hello,

I would like to display into a Table Box only data where the dimension named 'FTE' is > 0:

How can i manage that please ?

Thanks you in advance for your help,

Sébastien.

[marcus_sommer]

Within a tablebox are no calculations or conditions possible but you could instead use a straight-table which offers these features.

- Marcus

[sunny_talwar · Accepted solution]

You can try like this in the script:

If(FTE > 0, 1) as Flag

and then add Flag as one of the field in your table box and on the presentation tab check 'Omit When Value Is Null' option for Flag field.

Alternatively, you can use a straight table instead of a table box

[Anonymous]

Thank you !

[Anonymous]

I do not think so that it would be possible in Table Box...

You can do in Straight or Pivot table for sure..