I have exported some employee data including hours worked and hourly rate. I have attached an excel spreadsheet with a pivot table constructed form the data. I would like to be able to multiply the Grand Total of hours by the Hourly Rate to get a salary total in the far right column. Additionally I suspect it will be included in the column totals giving me a grand total at the bottom of the page as well as each department total. I am not sure if this is possible but I hope so. If you have any additional questions let me know. Thank You.
Bookmarks