How could i write Query expression

[nesanurisundar]

Hi All,

    I've expression like
   In  Data Item1 -- sales amount where month=?month? and
   In Data Item2 -- sales amount where month=?month?-1.
and i have prompt value in prompt page i.e., month
i've getting values for first data item but not getting value for second data item...
So how could i write the expression in data item

note: month value is in 2 digit character

Thanks
Sundar

[babu babu]

Hi Sundar,

Disable the global filter for month and change the aggregation property to total for the dataitem1 and data item2.

Thanks!
Anand.