Not sure how to display this data in a pivot table

makaveli80 · #7 03-23-2018, 06:37 PM

Quote:

Originally Posted by ArviLaanemets

What is this 'filter by template' at all? I did some google search, bot got nothing useful!

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).

How can I learn to do what you did above? is there a tutorial I could find? I'm trying to expand what you showed me and make it a dashboard where I can see specific stats such as per template stats.

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.

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