Capturing A Field
We have a commission database here and I am wondering if it is possible to capture a calculation at the end of each month.
For instance. We sort by month and then by salesperson and there is a calculation field that adds up all the commission that the salesman as earned so far in that month. Is there a way to set a feild to save that figure at the end of each month so that we can see all months side by side to see if they are doing better or worse.
Also, does anyone know of a way that you can add a chart to a layout? I would love to be able to have a line graph representing all of the salespeople to see where their commissions are compared to last month and see where we are compared to last year, etc.
Thanks for the help!