If you want to add numeric columns in a table, create a formula based calculated field and use the expression field1field2field3+field4 etc etc. . .
If you want to add down the page, you’ll need to create a summary. You can add subtotals by double clicking on the key field and use the options in the display tab.
I hope this quick answer helps out a bit. If you want more details, just ask.
I want to make a summary horizontal:
A B C D
In Excel I can use: Sum(A1:D1). What can I do in Monarch ?
greetings Oli /b[/quote]Oli,
If the A, B, C, D columns represent different values of the same field you could set the field to display ACROSS in the summary and then select the count format/method(s) that you wish to report. This will enable both horizontal and vertical summation.
If the columns do not currently represent values of the same field it may be possible to make a 2 stage process in Monarch where the first stage re-groups the data to make the analysis possible by the second part of the process.
Apoligies if I have not understood your requirements correctly.