expression to display prior date's images

[#1]

Hi,

Consider the following 2 tables

Table 1

Current_date	Img1	Img2	Img3
4/15/2012	Blue	Green	Red

Table 2

Date	Img1	Img2	Img3
3/15/2012	Blue	Green	Red
2/15/2012	Green	Red	Blue
1/15/2012	Red	Blue	Green

Note: these are all built-in QV images

Table 1 always keeps track of the most current month’sactivities while Table 2 keeps historic values.

I need to create 2 charts. Chart 1 needs to show currentmonth’s images and chart 2 needs to display prior month’s images. Getting chart 1 to work is straightforward. I get stuckwhile writing an expression for chart 2.

Based on the date selection I must also be able to selectprior dates and display images accordingly.

Any suggestions?

Thanks!

[#2]

solved it. used aggr(only( with a variable