A client has requested that I create a report that shows sales by category for a date range, summarized by category. They want to see what percent of the grand total each row is.

Is there a way to do this in GridView? I need to use GridView because of the other columns that they requested to be in the report.

Thanks

Steve

Like this.

Hi Andrew

I get the idea - using the GETLLINKEDRESULTS function - and that's great. I had actually figured out a more roundabout way to do it, but your way is better.

However, I don't think you attached the correct set of files. The formula was looking for a View called CatSummary.gv and there wasn't one included.

Thanks.

Sorry. Wasn't looking closely enough when I shift-clicked the files.