Expresion based on a selection in a field

[alec1982]

Hi,

I have a bar chart with the following expression:

=sum({<[ Acquisition Date]={'2012'} >}[Current Total Expenses])

Anybody can help me figuring out why it is not giving me the results based on the 2012.

I have the Acquisition Date in a list box and if I select 2012 the chart gives me the right nrs but if I dont select anything then it show me all values from 2012-2011-2010.

Thxs,

[alec1982]

I tried but it didn't work..

Not sure why!

thxs

[manojkvrajan]

Please upload a reduced qvw version and we can take it forward.

[alec1982]

While trying to simplify a version to send it to you guys. I was able to figure it out.

The field that I was using is not the right one.

My bad.

Thanks so much for your help.

Alec