I need to create an Excel report in NPrinting 17 that consists of three dimensions (Product Category, Product Type, and Product Description) and a group of measures, but for this example I am using one measure for simplicity. What I would like to do is have a subtotal row after each Product Type, a subtotal row after each Product Category, and then a grand total row at the end of the table. I am not too worried about the Grand Total row because I can create a second table with just the totals below the main table. I am trying to figure out how to handle the subtotal rows, however. Essentially, I am trying to recreate the rollup totals in a Qlik Sense pivot table. As of now, I am bringing in the report as one table object with no levels. Can anyone offer any advice? Thanks.
This is a new and different question so, please, open a new community conversation.
When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.