topic How do I add Subtotaled Dates to NPRINT Word Report? in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/How-do-I-add-Subtotaled-Dates-to-NPRINT-Word-Report/m-p/1281340#M15038 <HTML><HEAD></HEAD><BODY><P>I am looking for a way to subtotal a months worth of data using NPRINT. For example (see attached) I have the month of February I want to add subtotals to SO Quantity, SO Value and Estimated cost. Can I do this in NPRINT for a word doc by using a formula or other method? Or is the only way to recreate report by using Excel Pivot Tables/Subtotals?</P></BODY></HTML> Mon, 13 Mar 2017 20:07:45 GMT Anonymous 2017-03-13T20:07:45Z How do I add Subtotaled Dates to NPRINT Word Report? https://community.qlik.com/t5/Qlik-NPrinting/How-do-I-add-Subtotaled-Dates-to-NPRINT-Word-Report/m-p/1281340#M15038 <HTML><HEAD></HEAD><BODY><P>I am looking for a way to subtotal a months worth of data using NPRINT. For example (see attached) I have the month of February I want to add subtotals to SO Quantity, SO Value and Estimated cost. Can I do this in NPRINT for a word doc by using a formula or other method? Or is the only way to recreate report by using Excel Pivot Tables/Subtotals?</P></BODY></HTML> Mon, 13 Mar 2017 20:07:45 GMT https://community.qlik.com/t5/Qlik-NPrinting/How-do-I-add-Subtotaled-Dates-to-NPRINT-Word-Report/m-p/1281340#M15038 Anonymous 2017-03-13T20:07:45Z Re: How do I add Subtotaled Dates to NPRINT Word Report? https://community.qlik.com/t5/Qlik-NPrinting/How-do-I-add-Subtotaled-Dates-to-NPRINT-Word-Report/m-p/1281341#M15039 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">I would solve this by using Levels. You can use Levels per month. </SPAN></P><P><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">If you use you’re the same table in your Level (month), you will see an overview of all details and your total (You already have a total in your table, so this will be your total for your level)</SPAN></P><P><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Wouter</SPAN></P></BODY></HTML> Tue, 14 Mar 2017 08:18:28 GMT https://community.qlik.com/t5/Qlik-NPrinting/How-do-I-add-Subtotaled-Dates-to-NPRINT-Word-Report/m-p/1281341#M15039 woutermak 2017-03-14T08:18:28Z