is the formula working correctly? Qlikview does not export povot tables as true pivots so ther layout in nprinting is different than the layou in the Qlikview applicaiton, which probably accounts for the formula change
The templates are designed to be dynamic in order for the formula to work, regardless of the number of reos/columns
you may also notice that with a pivot table, when added to the editor, you do not get to move individula columns into the template like a straight table, so you do not ahve as much control over each column/cell to create formulas, but if your formulas or working, that is good to hear
you may need to create as a straight table in qlik 9maybe make a copy and hide it), bring into nprinting as a straignt table and then convert to pivot table in excel, due to the nprinting pivot limitations
Unless you want to write a macro in Excel, the way to do this is to build an Excel pivot table with the fields in your QlikView pivot tables:
- Take your pivot tables in QlikView, clone them and convert the clones into straight tables in QlikView.
- Follow this tutorial which will explain how to load the data and populate an Excel pivot table:
You'll have to log onto community to see the tutorial.