How to merge without subtotal Columns in pivot table created in NPrinting

[#1]

Hello Everyone,

I have created pivot table with 3 column headings in NPrinting. It has subtotal and Grand Total columns also.

When I tick merge and center cells with label in pivot table options box in NPrinting Template, I got error message as shown in below picture. So I remove the tick and save and open with preview and do same way in exported excel. every column headings can be merged. There is any way to overcome this problem in NPrinting?

Thanks for your suggestion in advance!

Here is the format we want to show in exported excel of NPrinting.

[Lech_Miszkiewicz]

Hi,

Are you actually building a Pivot Table in Excel - just like on your screen? The reason i am asking this is because in pivot view cells are merged automatically.

Can you share what you getting and what do you want to get ( i assume your end result needs to be like the one you presented) so maybe just show us what is your template (ideally attach it here)

thanks

this being said are you:

• exporting data from Qlik to Straight Table
• use exported straight table to create view like the one you have presented?
• How to Create a Pivot Table from Excel Table Columns

cheers

Lech

[#3]

Hello Lech,

Thanks for your reply.

I exported data from Qlik to straight table and converted into pivot table in Nprinting excel template Editor.

Below screen shot is the report generated from NPrinting. Cannot merge and getting error shown in picture 3.

Below one is the report once modified in pivot excel generated from Nprinting. Users need to tick merge and center cells with label in pivot table options box Manually.

In NPrinting template editor, if I tick merge and center cells with label in pivot table options box, I get error message as show as :

Users don't want to modify themselves in generated excel. Could you give me any idea to solve this problem.

Thanks for your support.

[Lech_Miszkiewicz]

Let me have a look into this i will get back to you later..

cheers

Lech