Rolling Of Months for given Data

[#1]

Hi all,

As i have been attached a excel file  SALESDATA  and i wanted Sum of [Sales amount] with rolling of 3 months

use [Invoice Date] for rolling month purpose.

the problem is the dates which are in [Invoice Date] are not in single form.

pls help me out.

Thanks

[sunny_talwar]

Are not in single form? What exactly do you mean/

[#3]

some are lik MM-DD-YYYY

and some M/D/YYYY

[Anonymous]

Hi

Please find the qvw you want...

I have used following expression for changing different FORMATS.

  Date#(Date([Invoice Date],'MM/DD/YYYY'),'MM/DD/YYYY') as [Invoice Date]

and

MonthInvoice     (please see the QVW)  is the KEY field for SELECTING last 3 months for Rolling  sum

Please check and let me know ..

[#5]

thanks,

[Anonymous]

Hi

FYI

Modified PIVOT TABLE

Please mark this as "Answered' if it is okay for you...