Trend Reporting For The Prior 12 months

[#1]

I have search a variety of .qvw files and this forum on how to determine a routine which would act as follows:

My application wishes to produce a mini chart sparkline of say total sales for the prior 12 months based upon a year select by the user via a year value select fron a List box. Should the user also select a month value from another List box, then the sparkline would reflect the prior 12 months ending in the year and month selected by the user.

Does anyone know of any examples or solutions I can look at?

[#2]

combination of set analysis, variables and some qv expertise do the job:P Please see attached file.

Cheers

[#3]

Thanks for the sample .qvw. I will look at it and see if I can make it work for my task.

Thanks again.