Summarizing or Grouping or What in Excel Sheet????????????????

Question

I am creating a report that does calculations on data and gives an output.  The current output that we do just straight through Excel is shown as file Sample Output Commission Report.  The Commission Report for ABC Company is what I am getting from my Workflow.  How do I make it look like Sample Output Commission Report through Designer.  I've been working on this for days using Summarize, Arrange, anything I can think of.  Please tell me it can be done!! 😥

All files below have dummy employee names, company names, etc.

Commission Report for ABC Company.xlsx

GP Sample.xlsx

Sample Output Commission Report.xlsx

Sample Commission Workflow.yxmd

Christina_H · Accepted Answer

Firstly, you have a lot of formula tools in your workflow - you can have multiple formulas in a single tool which will make things tidier.

This gets you a step closer at least, adding total rows and blank rows as spacers.  If you need formatting like bold on the total rows you will need to look into the reporting tools.