Thread: [Solved] Not sure how to display this data in a pivot table
View Single Post
 
Old 03-21-2018, 08:28 AM
makaveli80 makaveli80 is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Nov 2017
Posts: 16
makaveli80 is on a distinguished road
Default Not sure how to display this data in a pivot table
Hello everyone,

I have attached a spreadsheet, normally I know how to make pivot tables but in this case I'm not sure how to do it.

Y indicates that the block in the left column is applicable to the template

I don't understand how I can see things like overall completion per template, blocks per template, who the people are that are working on which block / template etc.

Do i have to redesign the table to make it work with a pivot?

Thanks in advance
Attached Files
File Type: xlsx Sample_worksheet_dev.xlsx (12.5 KB, 16 views)
Reply With Quote