I created crosstab in Crystal 9 where I've specified 2 groupings. I'm counting the number of products received each month. However, I want to have a running total of all the products we've receive since the beginning.
So let's say at the end of 2002 we received 200 TVs so I would add that total to the 2003 totals for each month.
1/03 2/03 3/03 4/03 05/03
TV 201 203 208 212 214
Let's say at the end of 2002 we received 100 DVDs
DVD 101 103 108 112 114
The query I've set up is correct but the results from the running total I set up in the crosstab are completely wrong. The results are too high.
In my row, I have the two specified groupings TV and DVDS. In my column, I have the date the product was received.
In the Summary section, I set up a running total formula where I count the number of appids because each product is issued an application id, then I evaluate each record and on change in the date.
What I'm I doing wrong?
Any advice?
So let's say at the end of 2002 we received 200 TVs so I would add that total to the 2003 totals for each month.
1/03 2/03 3/03 4/03 05/03
TV 201 203 208 212 214
Let's say at the end of 2002 we received 100 DVDs
DVD 101 103 108 112 114
The query I've set up is correct but the results from the running total I set up in the crosstab are completely wrong. The results are too high.
In my row, I have the two specified groupings TV and DVDS. In my column, I have the date the product was received.
In the Summary section, I set up a running total formula where I count the number of appids because each product is issued an application id, then I evaluate each record and on change in the date.
What I'm I doing wrong?
Any advice?