
Compare last 7 days to last calendar week V8.5
Hi-
I am using Crystal V 8.5. I am trying to create a 'sales by product'
report which would compare the sales data for the last 7 days to the
sales data for the last 4 calendar weeks (grouped by calendar week).
I can get a cross-tab table to display the calendar weeks. I then
thought I would make a second cross-tab to display the last 7 days and
put a separate record selection on that cross-tab to keep it down to
the last 7 days. Unfortunately it seems you can't put separate
selection criteria on cross-tabs.
Does anyone have suggestion of what else I can do to get the
comparison I need?
Thanks,
Kari