Sum of the ageing bracket

[SH_94]

Hi Community ,

I would like to sum up for all the ageing bracket amount as per screenshot below. May i know is there any formula that we can apply quickly to total up all the ageing bracket ?

[BenMoss]

The advice for this would be to transpose your data into a long/thin format, and then you can use the summerize tool (with the SUM aggregation) against your 'Value' column, grouping by the field that is currently making each row unique, you can then join your totals back against the data in it's current format.

The reason you would transpose, rather than use a formula is a formula requires you to specify field names, and is therefor not the most future proof method of doing this.

I've attached an example for you.

Ben

[echuong1]

The general recommendation is going to be to transpose the data, and then use a summarize.

An alternative method is to use the add totals Crew Macro. This will allow you to add column and row totals.

http://www.chaosreignswithin.com/p/macros.html