I have a report (CR8) based on detailed transactions of sales (ie Post month, product code, record type [debit or credit], qty, extended amount, customer code...these are the important fields).
After building an SQL based (MSSQL7) crosstab query to flatten out each month into it's own column...
...I have a Crystal Report summarizing each of the 12 months across the report. The report is grouped by Customer, then product, Fiscal Year, then finally record type [debit or credit], showing sub-totals for $ and qty sold for each record type group.
I'm looking for a way to track changes between fiscal years (i.e. percent change this May's gross (or net) sales vs. last May's sales, and dollar amount changes for the same comparison).
I'm guessing I need to build some type of running totals but it's not really a running total.
Can anyone give me a push in the right direction?
After building an SQL based (MSSQL7) crosstab query to flatten out each month into it's own column...
...I have a Crystal Report summarizing each of the 12 months across the report. The report is grouped by Customer, then product, Fiscal Year, then finally record type [debit or credit], showing sub-totals for $ and qty sold for each record type group.
I'm looking for a way to track changes between fiscal years (i.e. percent change this May's gross (or net) sales vs. last May's sales, and dollar amount changes for the same comparison).
I'm guessing I need to build some type of running totals but it's not really a running total.
Can anyone give me a push in the right direction?