topic Re: NPrinting Excel Report Dimension Subtotals in Qlik NPrinting

NPrinting Excel Report Dimension Subtotals

gbarrett — Fri, 17 Nov 2017 21:32:55 GMT

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			…

Re: NPrinting Excel Report Dimension Subtotals

Daniel_Jenkins — Fri, 17 Nov 2017 21:38:11 GMT

Hi George,

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

HTH - Daniel.

Re: NPrinting Excel Report Dimension Subtotals

gbarrett — Mon, 20 Nov 2017 17:44:54 GMT

Thanks Daniel. Worked exactly as I wanted it to.

Re: NPrinting Excel Report Dimension Subtotals

MuraliPrasath — Wed, 31 Oct 2018 09:09:49 GMT

Hi,

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

Please help me with this?

Re: NPrinting Excel Report Dimension Subtotals

Ruggero_Piccoli — Wed, 31 Oct 2018 11:43:37 GMT

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.