Table Design Changes

[sanchit089]

I am working to redesigning a table structure to put it into reports in a particular format. I have a table as given below, and for each group of Brand I want to calculate the total price sold for the brand. I can do the total part, where I can use the summarize tool with the union to have the aggregated rows merged between the data. What I am really stuck at is the part where I need to show the brand name at the top of each brand group(brand name is shown on top of each brand group). Also, the brand name group text is 1 complete cell in the entire row. 

I would appreciate if someone could help me with this. 

Input Table:

Brand	Product	DatePurchase	Price
Nike	T-shirt	2020-08-14	13.99
Nike	Cap	2020-08-14	9.99
Adidas	Tshirt	2020-08-14	15.99
Adidas	Shorts	2020-08-14	20.99

Output Table:

[DavidP]

The output data tool can't do merged columns. The only way really is with Reporting tools.

Have a look at the workflow attached

[DavidP · Accepted solution]

Sorry @sanchit089, I was in a bit of a rush this morning. Here is the same workflow with documentation to show what every bit does. I've added a little bit of formatting too, to the header color using default table settings in the header table tool, and the merged cell background color in the Text Tool.

Let me know if you have any questions

[sanchit089]

Thanks, @DavidP, this is exactly what I was looking for. Thanks for the documentation as well, it was very helpful.