Dear Members, i Need to get solution of the problem. i have nearabout 50 sales persons and each month i need to calculate the sales of the men manually. More than 4 years of data is in excel file, and i need to get total sales of each individual person monthwise. As i tried this through pivot table, but it gives me the total sales of all months. is there any solution in which i get rid of this and get easily sales of the current month or any specific month
Hope to get any solution
Regards
Bookmarks