BoomerBroomer
MIS
I set up a planned sales table and an actual sales table with exactly the same stucture with the aim of doing a crosstab query to make my reporting easier. However, I identified the planned sales with a "P" in a type row and actual sales with an "a" in the type row (I used a common "sales" row to capture the dollar values). When I do my crosstab query, I get two rows for each customer (an "a" and a "p" row) with the correct numbers for each of the months - 1 to 12, with a total field taht adds up for each type.
My problem is that I'm grouping by sales rep and although each customer within the group shows an "a" and a "p" line, the rep total adds them both together and I can't figure out how to get a rep total for both "a" and "p".
I also want to show the percentage growth from plan but by using the common row "sales" for both Plan "P" and Acutal "A", I can't figure out how to do that either.
There's got to be a way, but I can't get my head round it.
I would appreciate any help.
Thanks
My problem is that I'm grouping by sales rep and although each customer within the group shows an "a" and a "p" line, the rep total adds them both together and I can't figure out how to get a rep total for both "a" and "p".
I also want to show the percentage growth from plan but by using the common row "sales" for both Plan "P" and Acutal "A", I can't figure out how to do that either.
There's got to be a way, but I can't get my head round it.
I would appreciate any help.
Thanks
