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.