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:
Solved! Go to 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
Thanks, @DavidP, this is exactly what I was looking for. Thanks for the documentation as well, it was very helpful.