How to Calculate Running Totals by Key Field in Monarch Summary

Al_22614

Hello Team:

Could anyone advise how I may calculate a Running Total within a Subtotaled Key Field (Region).  I am familiar with using ****() for a whole report,  but I need the running total to apply within each Key field which is subtotaled.

Thanks in advance

Al

Nicholas_21406

Hi Al,

Please try the attached ****.dpwx(.txt), which takes an input file of Book1.xlsx, which looks like this: 

Transforms it using a Summary which is configured as follows:

and exports to a file which I have imaginatively called Sheet1$.xlsx

(Note you will need to rename ****.dpwx.txt to ****.dpwx in order to use it.)

 

Shelton Vance_22282

Sorry that I don't have an answer, but I appreciate your directing me to the ****() function.  I needed that yesterday.

SV

Al_22614

Thanks Nicholas: 

 

Works very well in DPS.  Is it possible to do same with Monarch Classic?

Thanks

Nicholas_21406

Quite welcome.  I'm not sure if this could easily be done in Monarch Classic or not.  I would probably have to direct you to Professional Services, or else you could ask during our next Ask The Expert session, https://web.altair.com/ask-the-expert-monarch-series

Al_22614

Thanks Nicholas

Mo Abdolrahim

Al_22614 said:

Thanks Nicholas

Please see attached zip file that shows how to create a summary in Monarch Classic for running total.

Mo