I would like to display only rows into the Straight Table where Values are presents in all Expressions:
How can i do that please ?
Thank you in advance for your help,
As first step, unhide this new expression and check that it shows -1 on all lines where each original expression shows a value and 0 if at least one original expression does not show a value.
If this is successful, label this expression COND,
Then e.g. for your first original expression, write:
=If( "COND", Only(Nom_DHACCOR))
For the second:
=If("COND", Only(Employee_CD) )
Now you should only see the lines with COND =-1, if 'suppress zero values' is enabled on presentation tab.
Now hide the expression column COND on presentation tab.
Then i have a problem i do not have the same result than my Table box:
Table Box values:
Straight Table Values:
the the lines with the same Matricule dissapear in the straight table.
Do you have an idea ?
If you want to see two lines for the same Matricule, you would need to add a dimension to group your data into a finer granularity, e.g.using FTE (two distince values per GL001348465 Matricule).