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)
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
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.