Calculation Condition Unfulfilled

[#1]

I know this should be very simple, but I can't seem to crack it!  How do I apply a simple calculated condition on a string value?

I want to filter CustomerID on the value of 'AAAAA' using the formula:

CustomerID = 'AAAAA'

Please see attached QV file and screenshot

[jonathandienst]

Hi

It works as designed - the condition is fulfilled when AAAAA is selected and the table box displays.

Perhaps you want to filter the data for the 'AAAAA's regardless of the selected value. Then you would need to use a straight table (not a table box) with Date as a dimension. Then use this expression:

     =Sum({<CustomerID = {'AAAAA'}>} Amount)

HTH

Jonathan

[#3]

Thanks for that clarification, I didn't realize that the Conditional Expression only works on selected values.

I tried adding the straight table with the formula you suggested, but it still doesn't filter on the AAAAA records.  Can you please take a look?

[rubenmarin]

Hi Carleton,

You can filter using set analysis, check the expression on file attached.