Reporting

[sarithaligonfin]

Hi there, 

Is there any way I can merge cells in a table the way it is shown in the expected output below? 

My input: 

Field 1	Field 2	Field 3	Field 4	Field 5	Field 6	Field 7
Store 1	Capital	1	2	3	4	5
Store 1	Operating	5	10	15	20	25
Store 2	Capital	1	2	3	4	5
Store 2	Operating	5	10	15	20	25
Store 3	Capital	1	2	3	4	5
Store 3	Operating	5	10	15	20	25
Store 4	Capital	1	2	3	4	5
Store 4	Operating	5	10	15	20	25

My expected output:

Thanks,

Saritha 

[atcodedog05 · Accepted solution]

Hi @sarithaligonfin 

Here is how you can do it.

Workflow:

Output:

Please go through the workflow and let me know if you have any questions 🙂.

Hope this helps : )

[sarithaligonfin]

Thanks heaps! 

Is there any tips on how to align the cotents of the field 1 in the middle? 

[atcodedog05]

Hi @sarithaligonfin 

You can set a row rule that would be the efficient way to center align all columns. If its only for specific column you can alignment for a specific column in table tool.

Hope this helps : )

[atcodedog05]

Happy to help : ) @sarithaligonfin 

Cheers and have a nice day!

[sarithaligonfin]

Sorry, I didn't word that question properly.

I meant align the contents "middle - left aligned"

Thanks

[atcodedog05]

Hi @sarithaligonfin 

Sorry that is not possible as far as I know 😅

[Jafar]

Need to create a PDF with desired output.
I need all the dimension on top of the dataset for each group.
Similary there can be multiple group in a single report.