NPrinting Excel Report Dimension Subtotals

[gbarrett]

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.

Product Category	Product Type	Product Description	Sum of Sales
Cat 1	Type A	Product 1	3
Cat 1	Type A	Product 2	4
Cat 1	Type A	Product 3	5
Subtotal Type A			12
Cat 1	Type B	Product 1	5
Cat 1	Type B	Product 2	6
Cat 1	Type B	Product 3	7
Subtotal Type B			18
Subtotal Cat 1			30
Grand Total			…

[Daniel_Jenkins · Accepted solution]

Hi George,

Take a look at How to Create Excel Reports with Nested Levels and Subtotals

HTH - Daniel.

[gbarrett]

Thanks Daniel. Worked exactly as I wanted it to.

[MuraliPrasath]

Hi,

How to maintain only one Main column names for all nested levels.

Please help me with this?

[Ruggero_Piccoli]

Hi,

This is a new and different question so, please, open a new community conversation.

Best Regards,

Ruggero

---------------------------------------------

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.