![]() |
|
#1
|
|||
|
|||
![]() 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). |
#2
|
|||
|
|||
![]() 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. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |