display row only if all row populated

[Anonymous]

How will I display only rows  that have both data  in Try and Win rows?

so I am after:

Thanks

Raphael

[vishsaggi]

Check attached.

[sunny_talwar · Accepted solution]

Use the same if statement that you used for your third expression within the 1st and 2nd expression

=if(Try>0 and Win>0, Try)

=if(Try>0 and Win>0, Win)

[Anonymous]

Thank you

[Anonymous]

Put your condition as a calculated dimension rather than name:

=if(Try>0 and Win>0, Name)