chainedtodesk
Programmer
i have a table that has 3 years of data in it. the data is broken out by a salesman, a product type, sales dollars, year. i was able to use a cross tab to get the records to disply as needed for management, but now they are requesting a difference column either dollars or percentage but it needs to be at the individual salesman/product level. i tried to do running totals but i cant get it right based on the 3 different criteria salesman/product/year and adding a column to the cross tab grid doesnt help im not sure how to code it there either. any help would be muchly appreciated. thanks all