How to restrict 3months in pivot table

[#1]

hi,

I would like to know how to display 3months of a year (Current month and previous 3 months) in the pivot table.

Can someone help me to get the solution for the same.

Thanks and Regards,

Smitha

[#2]

Can you attach your qvw file please? You can get this done easily by using a set analysis in your expression.

Sum({<Date={">=....."}, Date={"<=.."}>} Sales)

[#3]

hi,

i dont have qvw file. i have to create application still. I have the requirement in xls.please find the xls for your reference.

Thanks and Regards,

Smitha

[#4]

You can have 3 expressions.

expression 1

=sum(if(Month(Transaction_Date)=Month(Today),Metric)

expression 2

=sum(if(Month(Transaction_Date)=Month(Today)-1,Metric)

expression 3

=sum(if(Month(Transaction_Date)=Month(Today)-2,Metric)

[er_mohit]

See the attached qvw