- Qlik NPrinting 17.x and higher
In NPrinting excel report template, create a pivot table with 2 or more column dimensions.
The resulting Pivot table should show the rows and columns normally and subtotals should appear only once.
- The outcome shows the subtotals twice with random rows emboldened.
- This is corrected if the sections in the table are reduced and expanded back.
This will be fixed with the bug OP-7187. Until the fix is in place, the following workaround can be used.
While in NPrinting Excel template, navigate to the Pivot Table Options->Data and check the option "Refresh data when opening the file"->Press "Ok"
You should have the outcome in the expected format now.