I have a chart table with these fields: Date(dimenssion), Invoice_num(dimenssion),line(dimenssion) , Quant(expression).
The table shows invoice's lines.
What I want to do is to show in the table only lines which don't fall in the selected range of dates.
mean to say that if I have for example :
01/01/12 1234 1 40
01/01/11 5678 1 50
05/04/11 8098 3 40
and I have selected Year = 2011 and Months = feb and Apr , I will see in table only lines 1 and 2.
I used your expression for the Quant field, but I still get all lines. I think i should use kind of calculated dimenssion, for my date field but can't figure which expression I should use. I tried yours but it stil dont work.