Chart: Need help with a conditional sum

[#1]

I have a set of Order transactions. There is a transaction type that indicates whether the Order is a sale or return. I would like to create a chart that shows Returns. In other words, I would like to filter my Orders to only display the Sum of Orders where TransactionType='RP'

How would I do this?

(Thanks in advance fo your help)

[#2]

Hi,

You could do this with Set analysis.

Try this ;

sum( {$<TransactionType = {'RP'}>} order)

Best regards.

[#3]

Perfect! Thank you!