Link Filter Criteria into Caption

[jmonroe918]

I have a container holding 3 text objects (TX100, TX101 & TX102). TX100 has the following expression:

=Count({<[CAPA.Status]-={'Closed'},
[CAPA.Division] = {'VST'}
>} [CAPA.CAPA No])

The other two text boxes have similar expressions, the common thread is the [CAPA.Division] = {'VST'}.

Is it possible to force the "VST' into the container's caption? That way when I change out the text boxes with different divisions, I don't have to retype the division's designation every time?

Thanks.

Jeff

[#2]

Did you tried using Only() function.

In my case I used something like : =only({<itemid={26}>}address) in the Title of a chart.

This will return me the Address Name of Itemid=26.

Is that what you are looking for?

Thanks,

Angad

[jmonroe918]

Angad:

What I have now in the container caption is "CAPA - VST".

I would like the 'VST' to match whatever is entered in the expression of the Text Object.

Thanks.

Jeff

[sunilkumarqv]

try this

='Division '&FirstSortedValue(CAPA.Division,-Aggr(Count({<[CAPA.Division] = {'VST'}>}[CAPA.CAPA No]]),CAPA.Division))

[jmonroe918]

Sunil:

Sort of, Except I want it to depend on what is in the 3 text objects. I have 7 other containers on the page with data from different divisions.

Jeff