Myself Nikhil and I want to know an equation for the attached sheet.
Here I have to take daily report and want to get the percentage of each sales man.
My requirement was simple but confused. here I have two table one with summary and the other with daily sales. In this summary daily sales there is a dated column. I want to get the values from daily sales column to summary column by changing the date.