Dimensions in text boxes

[dlesny]

Hello

Currently I am using Gauge Chart the Digital Numbers style on which I am setting the Dimension:

=BC='BC1' and then using the expression: =(if(BC='BC1',Avg(BC Score)))*100, which gives me the results I want but people do not like the greyed out area on the charts for the bits not on so I need to change it to Text Object.

How can I transfer this to Text Object? How do I force the =BC='BC1' on the Text Object?

"If" is not enough and generally this is not on, but I want this Text Object to  look only at BC Score at BC1 level. 

[AxNoxy · Accepted solution]

I guees i dont get correctly what are you planing to do, but with Set Analaysis on the text object would be enough? Something like this?

Avg({<[BC] = {'BC1'}>} BC Score)

Regards!

[dlesny]

Perfect! Thank you very much, exactly what I was looking for.