Stuck! Creating a Dashboard from a Sheet from a Report from Sheets. :/
Maybe I'm making this harder than it is but I can't figure out a way. I'm working towards ultimately building a Dashboard Chart (Pie Chart) based on Summary data from around 54 project schedules. I've created a Report that contains the information I need from the Summary information from each schedule (54 lines of summary information). I then want to create a table based on that data so that I can use it in a Chart in a Dashboard. However, I can't seem to get the Report to group the same way I can do in a Sheet. I can do it when I use a Sheet that uses COUNTIFS to another sheet but I can't do that as a Report to another Report.
Basically, I need a table from my Summary Report that ultimately looks like the attached or some other suggestion that gets me to that same end.
Help Article Resources
Check out the Formula Handbook template!