Thanks, the final script summed all required details.

Output required mentioned in the attachments of first post in Table (4) where last column obtained with the query mentioned in my last reply. I will join the ones provided...

Thanks Jonathan,

What are the total purchases of unique customer is the tricky part. The query gives the total of purchase for each customer at each store. There are 3 stores...

• This reply was modified 3 years, 10 months ago by  Rehan Ahmad.

Dear, not homework. I done a lot and tried by using joins but stuck on the final result where total purchase of each customer required to be plotted (against those...

I have upload such similar file with Ragged Right option and setting fixed width. Problem is with lines in the start and end and report description mentioned in the top...