Forum Discussion
weekly status report
Hi Vin
You can actually use my pivot table but if you want to follow the steps to create your own you need to do the following:
- Select any cell in your pivot table
- This will display the PIVOT TABLE TOOLS at the top right hand of the ribbon
- Select the DESIGN option
- On the far left select the Report Layout drop down and then choose Show in Tabular Format
- Also on far left sect the Subtotals drop down and then choose Do Not Show Subtotals
- The Sum of Effort in Hours columns defaults to decimal; you need to change the format to HH:MM; Place cursor on heading cell, right click mouse and select Value Field Setting; This opens a new window so select Number Format , then choose Custom; you can scroll down the values until you find hh:mm or you can type hh:mm if you can't find it in your list.
I hope you can follow these steps!
regards,
Peter
If you provide the file it'll be easier. I attached what I thought would be best.
Create a new tab, go to each tab where you've labeled per week, copy the entire data set, go to the new tab and copy it that to a brand new tab, repeat for all the tabs labeled so you have one tab with all weeks in it, click into the data and press Control+T to create a table, check the box that your tables has headers, and you're done.
It would be much better if you complete this and then create a pivot table based on this table of data because you can visually see this, filter, and show the data in a more meaningful way than just in a table.
Jpalaci1
Dear Jpalaci, I attach the document. As suggested, it might be easier 🙂
Jpalaci1
Aweasome, thank you! while updating this spreadsheet I always have to create a tab of the current week. Correct?No, it'd be more effective to add to the new to the consolidated one and ditch the week tabs. Just make sure to label each week when added. If you do choose to manage then just have that week with the consolidated one and then add to consolidated and then delete that week's data.