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.