Datamesh from a summary report

hi! I am trying to build a means to automatically forecast vendor costs, based on a count.


I have a large sheet that contains an intersection of many Locations and the Scopes that will be applied to each location. I have different vendors servicing my various locations. I have created countifs formulas to count the number of Scopes per Vendor (and that is working well).


I have generated a scope summary report to output the results of the countifs.


I want to datamesh this report into a sheet so that I can multiply the counts by the vendor rates. I am able to select my summary report and I am able to select my target sheet. When I click the NEXT button after that, I receive an error message that says "Oops! something isn't running correctly. We'll have someone look at it asap."


Any ideas as to what could be wrong? Or other thoughts on how to complete my task at hand?


Thanks!

Answers