Presenting data of two sucessive months in two tables

[#1]

Hi,

We have developed 1 report in which we have created a table. The table shows different engagements and percentage of productive and non productive hours on those engagements. Once we click on 1 particular month in the list box data of that month should reflect in first table and data for next month should reflect in another table.

Can anyone please help in this case?

[johnw]

Your second table could override the month selection using set analysis. If your month field is the first date of the month formatted as 'YYYY MMM', for instance, and one expression in the first table is sum(ProductiveHours), the equivalent expression in the second table might be this:

sum({<Month={'$(=date(addmonths(Month,1),'YYYY MMM'))'}>} ProductiveHours)