#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Oprion 1: Use autofilter on your table;
Option 2: Design a report like in attached (updated) workbook. |
#3
|
|||
|
|||
amazing, thanks! - this is great. Just wondering when I "summarize with pivot table" i don't have the option to filter by template.
Also, just curious how you learned all this? I was looking at the named ranges and formula you used, I could never have thought this up |
#4
|
|||
|
|||
A time is all you need
|
#5
|
|||
|
|||
Ok cool, and I was wondering when I "summarize with pivot table" i don't have the option to filter by template? how can i add that to my pivot table? so i can make graphs and stuff
|
#6
|
|||
|
|||
Quote:
There is a filtering option for pivot table, but it looks like this is not you are after at? I myself use pivot tables seldom - mostly I only give help when some user has problem with them. Usually adding a calculated column into original table is enough. For graphs I prefer report sheets with data validation lists to set up conditions, or I create a ODBC query which returns a table for graph (again, I use data validation lists for selecting query parameters, and the query is set to automatic refresh when any parameter is changed). |
#7
|
|||
|
|||
Quote:
So I'm trying to figure out how to calculate for example if template 1 is selected, how much % is it complete. So I can find that information out in 2 ways: # of blocks completed out of total # of blocks in Template X or Add up all the percentage completed, per template, and do an average. That's why I wanted to create a pivot table, put in "template" and then from there I can look at # of blocks in template, look at who is assigned to working on which blocks within that template etc. |
#8
|
||||
|
||||
@makavell
Hi please do not quote entire posts unnecessarily. They clutter the thread and make it hard to read. Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#9
|
|||
|
|||
ok thanks ArviLaanemets ! i am going to do more research on Advanced Filters
and mark this as solved; i don't understand it though, cannot replicate it |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data not showing in Pivot Table | MichelPierre | Excel | 2 | 01-26-2016 10:51 AM |
Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
Pivot table - I cant display item labels when no fields in value area | differentdrummer | Excel | 0 | 12-12-2013 05:13 PM |
Pivot Table Duplicate Data | cnw | Excel | 0 | 08-31-2012 08:24 AM |
pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |