First, I like most must thank you for all of the great guidance you put on youtube it has helped me more than you would ever know!
My issue revolves around tracking not one project and its sub-task but hundreds with their own subtask. I queried all of the subtask statuses and paired them up with the main projects. I want to get my dashboard to count only the projects that are fully complete and the ones that still waiting on completion.
I created a made up sample of what I'm looking at. Basically, the task is to be able to see how many of the projects are completed overall, and each project's progress. If you look at the attachment I feel like I am almost there but in the end when I create a table referencing the pivot table it doesn't work because it doesn't work with pivot table filtering. In the back of my head, there has to be a better way.
I apologize if this is not in the scope of this forum but I'm going crazy trying to find away.
I think that I might have gotten it to work by creating a table based on the pivot table and build a new pivot on the new table with finally referencing the grand total. If there is a better way please let me know. See attachment for changes.
Hi Ben,
I would recommend Power Pivot DAX measures for this as your table solution with formulas won't automatically grow with new data. In the attached file I've inserted 3 measures in a PivotTable (orange theme). Hope that helps.
If you'd like to learn more about Power Pivot and DAX measures, please consider my Power Pivot course.
Mynda