I have attached the sample qvw. i have to give sales summary for all customers in one table and for customers with points in other table. i have customer table with targets, points1 and points2. i have to calculate points3 and then i need to give summary for customers with points. to calculate points3, the case stmt in sql is attached.
