This does give me a chart showing a store number, and then the sum of sales where transaction amount is $2.
However, it is then ignoring any selections I make in list boxes (for instance, I have a list box that is for date, and no matter what selection I make in this list box (or any other list box), the table shows a list of all dates, and all stores, with their sum of $2 transactions.
Set analysis is new to me, so do I have the syntax wrong? I thought that using $ would give me the set of current selections, except add in a filter for transaction_amount.
All objects are in the same state, as the chart works fine when the expression is sum(TRANSACTION_AMOUNT), except it shows all transactions.