To change employee click on toggle in top left-hand corner. See screen shot below which is for Employee Number 20. Workbook should open to the Worksheet called:.
I am also using Power Query, so I can create a new column with a formula, if that would be an easier fix I'm just not sure what formula to use.ĭownload the file and save it off to a local folder. I would also like the formula used to continue to update as new months start to have data. I want to create a pivot chart that compares how many assignments each employee completed in 20 for Jan, Feb, Mar, Apr, and May (current month). I created a pivot table and chart in Excel from a sharepoint list and would like to be able to show a true year over year comparison that will look at only the months so far with data for this year and compare the same months from the previous year.īelow is the pivot table that has employee numbers and the amount of assignments they completed each month.
0 kommentar(er)
