Group Cross Table ... I have a big problem

[martine]

Hi,

I have a big problem with a cross table.

2002 2003

sales quantity discount sales quantity discount

$ $ $ $ $ $

2002 2002 2002 2003 2003 2003
total total total total total total
sales qty disc sales qty disc


And I have lot of calculations in my footers ... And I start with a prompt with last begin date, last end date,
this begin date, last end date.

BUt Now we are in 2004... I put 2003 and 2004. And all my calculation disappears in my footer because last year its total (sales 2002) and total (sales 2003)...

How can I fix this ...


thanks

Martine