I have a sales Database as under:
Date,Sales Person,Vendor,Sales Amount
4/1/13,A,XYZ Ltd.,4500
4/3/13,B,AAA Ltd.,3000
4/3/13,B,BBB Ltd.,3000
5/3/13,A,BBB Ltd.,2500
6/1/13,B,AAA Ltd.,5000
I want to extract data from the above database based on the selection of the month. If I select April' 13 it will show below:
Date,Sales Person,Sales Amount
4/1/13,A,4500
4/3/13,B,6000 (Sum up sales amount happened in same date under a salesperson)
Please help me and thanks in advance.
Bookmarks