How to add extra row with reporting tools

[xariet]

Hi All! 

I need to add a row on top of the existing table with a Table reporting tool. Is it possible? My current workflow and desired output are attached. Thank you in advance for your help

Update: sorry, I forgot to mention that I am getting raw data for multiple customers and at the end, I want to generate different tables for different customers. With the solutions provided below grouping by a customer in the Table tool doesn't work. I have attached workaround workflow provided in the solutions with my changes.

[ericsundby]

There are many ways to accomplish this, but this was what I came up with (workflow is attached). Let me know if this works for you.

[xariet]

Thank you, this is a good solution, unfortunately, doesn't work for my case. If I have multiple customers and want to create a table separately for each customer it doesn't work. I have attached your workflow with my changes

[grazitti_sapna]

Hello @xariet, give this a try.

I hope this helps!

Thanks!

[binuacs]

@xariet one way of doing this. Similar to @grazitti_sapna method

[xariet]

thank you, please see the update in my post

[xariet]

Thank you Sapna Gupta, please see the update in my post

[binuacs]

@xariet Are you looking for the output of each customers in separate tab in an excel workbook or something like below

Or something like below

[binuacs]

@xariet attached workflow will create reports in separate tabs in an excel workbook like below

[xariet]

sorry for the confusion. when I get raw data with multiple customers I need to generate for each customer separately an excel spreadsheet with this table (to be able to email them later). I think I know how to do that, the problem now is to match the template - add a row on top of each separate table with headings, like in the final outcome example (yellow top row needs to be added to each table for each customer)