How can I choose specific values for a Chart based on a String?

[#1]

Hello,

I have a straight table where I need to list a set of values based on another field as the first dimension. I have tried multiple approaches to this and come up with nothing. Essentially my field "SC03" contains "A", "B", "C", or NULL for every record in the source table. I need the chart to only display values from my field PRODWHID where the corresponding SC03 value = "A". I have tried the following combinations:

=Aggr(SC03='A',PRODWHID)     Results: NULL

=Aggr(PRODWHID,SC03='A')     Results: NULL

=If(Aggr(PRODWHID,SC03)='A',PRODWHID)      Results: NULL

=If(Aggr(SC03,PRODWHID)='A',PRODUCTID)     Results: NULL however works with ListBox

I do not currently have any other expressions in this chart. Is there something that I am doing wrong or another parameter that I need to include?

Thank you for any help you can offer!

[Gysbert_Wassenaar · Accepted solution]

Try with PRODWHID as dimension and Sum({<SCO3={'A'}>}1) as expression. If you want you can hide the expression on the Presentation tab of the charts properties window.

[#3]

That got it! Now I have a place to start from. I appreciate it gwassenaar‌!