total of column at the end

Question

Hi Team,

I have Following Data-set

CostsYEAR 1YEAR 2YEAR 3YEAR 4YEAR 5Ex Project Costs 1500000Ex Project Costs 240010000Ex Project Costs 3060000Ex Project Costs 400000

Expected out-put:

CostsYEAR 1YEAR 2YEAR 3YEAR 4YEAR 5TotalEx Project Costs 150000050Ex Project Costs 240010000140Ex Project Costs 306000060Ex Project Costs 4000000Total906010000250

DataNath · Accepted Answer

Hey @BRRLL99, here's a couple of ways of doing this...

1) Use the Add Totals macro, created by @MarqueeCrew and co - http://www.chaosreignswithin.com/p/macros.html

Just tick 'Add Total Row only'

2) Transpose your data and then re-Cross-Tab. Within the CT configuration, there's an option to add a Total Row (you still need your initial aggregation):

I've just used the Dynamic Rename at the end to clean the headers back up. If this is messing with any existing headers then let me know as there's a full work around for maintaining naming:

Hope this helps but please do let us know if you still have any problems!

flying008 · Accepted Answer

Hi, @BRRLL99

There is 2 easy ways to get your want output:

1- used CreW macro Add-Totals.

2- Transpose + CrossTab.

*********

Please mark it is a solution and give a like with if it help you get want output.

BRRLL99 · Accepted Answer

Hi Guys,

Thank you For your Help

I Have used different scenario and got the expected output

DataNath · Accepted Answer

No problem @BRRLL99 - for future reference, the Add Totals macro also has an option to add both a total column and row! :)