Set Analysis In Expression

[#1]

Hi There

Can we have set analysis as expression of a chart based on  a dimension?

In my app, I have quarterly sales person quota. Quota table is not associated to sales table. In my sales analysis chart, I would like to compare sales versus quota. In dimension, I have quarter and in sales expression  I have sum (salesamount). For quota expression, can I have sum( {$<QuotaQuarter={SalesQuarter}>} Quota)?

Thanks

[danielrozental]

If you are selecting a Sales Quarter first then your expression should look like this

sum( {$<QuotaQuarter=P(SalesQuarter)>} Quota)

On the contrary, if you don't want to force a Quarter selection then your expression should be like this.

sum( if(QuotaQuarter=SalesQuarter, Quota))

This will probably not work that great unless you do a sum distinct, it might be a good idea if you can post a sample qvw.