Nprinting - 3 pivot tables with the same dimensions

[AlbRodero]

Hello,

I am trying to create an xlsx report with three native pivot tables. I can't have a single big table, due to the nature of the data.

They work well independently, but I need to set them one after the other to make the illusion of a single table.

I have two challenges

1. Hide the Dimension column of the tables 2 and 3
2. Table 1 always has the same columns but table 2 can have more or less columns depending on selections and need to adjust the start of table 3 to begin right after table 2.

Thanks in advance

[Frank_S]

Can you provide a mock up of the result you are trying to achieve?

[AlbRodero]

I got to merge together table 2 and 3 so point 2 is fixed

I need to hide the Dimension column of table 2.

In the attach you can see the desired outcome and below the result so far

Thanks

[Frank_S]

Try this. It's an old video with NPrinting 16 as the designer but the design principle is the same.

(Note: You'll need to make a copy of your pivot table and convert it to a straight table and use the straight table for the cell by cell report.)

• https://youtu.be/YiTy_cPqRSk?t=3181

KInd regards...