How to add extra row with reporting tools

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.

final outcome.xlsx

workflow.yxzp

workaround.yxzp

Reporting

Accepted answers

All comments

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.

Sub-Header_Workaround.yxzp

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

workaround.yxzp

grazitti_sapna

Hello @xariet, give this a try.

I hope this helps!

Thanks!

Engine_77164_fc7be2db230e49c6ad9a22707da81ddf_.xlsx

adding headers_updated.yxzp

binu_acs

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

Create_Rows_14_07.yxmd

xariet

thank you, please see the update in my post

xariet

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

binu_acs

@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

binu_acs

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

Create_Rows_14_07.yxmd

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)

final outcome.xlsx

111.png

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167