Adagio GridView is meant to provide fairly straight forward reports from single tables or from tables that can be hooked together as "composite" tables. GridView does not replace all the capability of Report Master, in particular when ReadBack tables are used!

Seems likely that GridView is not the tool for this report. Perhaps what you need is a Custom Report from Sales Analysis.