Multiple cross table in one view

Hi Experts,

I would need help to populate 4 cross tabs in one single view. Please refer attached desired output.

All cross tabs have different Record IDs with headers coming in as Text.

All records have different row and should fit in the same view. should not extend beyond one page when Rendered to a PDF.

Thanks

Multiple Cross table in one view.pdf

Reporting

Accepted answers

danilang

Hi @Srini_Advik

Here's the basics of how you would do that

You start by add in the table header as text to each table. The you join the first 2 tables horizontally and then take these snippets and join them horizontally.

The ability to fit on one page depends on the number of rows that you have in your data.

BTW. It's customary to provide some sample data when asking for help. We're all volunteers here and any thing you can do to make our job's easier makes it much more likely to get an answer

Dan

4Tables1View.yxmd

All comments

ChrisHe

Hey @Srini_Advik ,

Is it possible to provide some sample data you're working with so I can make this more tailored to your use case? In general though you would need to separate out your data into the 4 cross tabs you need with Filters or via batching in the "Table" tool in the Reporting palette. Happy to take a look if you can provide to give more guidance on the path I'd take.

Once you have the data separated into the four tables reporting snippets we can use the "Layout" tool under the Reporting palette or the "Visual Layout" tool under the Lab palette to arrange the tables before rendering to PDF. Let me know if this helps and if you can provide more detail on your source data.

Srini_Advik

ChrisHe

With My apologies.

Due to confidential data i would not be able to provide the workflow or the data. Kindly request you to use some random data to prepare the workflow with your suggestion and provide me the workflow.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703