Text Object Query

[vikasshana]

Hi,

I do have the below table. 

Country	Total Cases	No Cases
India	100	10
Brazil	200	20

My Requirement is i need an expression in text object which shows only Brazil Total Cases (i.e. 200)

Regards,

Bharath Vikas

[lujsantos · Accepted solution]

Hi,

You can use Set Analysis for this.

=SUM({$<Country = {'Brazil'}>} [No Cases])