Skip to Content
0
Former Member
Mar 18, 2009 at 03:03 PM

XLReporter ThisYear/LastYear

20 Views

I am trying to produce a report with XLReporter that would simply display the sales of products by period for this year and last year.

The way the report runs, I simply added a column expension on the periods (which are parameters the user keys in), then I print the item number, the sales $$ by period.

For the current year I have no problems, I am having a problem attempting to add the sales $$ the same period of last year.

The layout would be like;

Period 1 Period 2 ....

Item Number $$ This year $$ This year ....

$$ Last year $$ Last year ....

I just can't seem to be able to refer to the period of the columns in order to select the same period of last year.

Does anybody know how to do this ?

Yves Beaucage