Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I would solve this by using Levels. You can use Levels per month.
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)
Wouter