Could we make the calculation to a "Report" file?


Hey guys, now I have a question asking for your help:

Now there are many project schedule in my workspace, so I use the "report" function to filter some key info and data that I want to summarize and show to the the management team.

Could we just make a calculation to a "report" file then create a dashboard from it? Or if there is a more convenient way? (Now I need to create a new sheet then copy the filter result then do the calculation job)