Calculating Row wise differences

[ksasidhars]

Hi - Can anybody let me know how to achiev a row wise differences.

For Example the 'Name' and 'Month' are the existing fields in the Pivot below, How can I calculate difference here. The data is coming dfrom a huge Fact with many columns.

Name	Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Row I		29951.72	8800	40674.92	74612.46	-16337.54	25276.65	100	9388.71	14383	22162	16099	41760	266870.92
Row II		29659.82	29659.82	29659.82	29659.82	29659.82	29659.82	30969.85	30969.85	30969.85	30969.85	30969.85	30969.85	363778.02
Difference												105.6

Thanks for the advise!

Regards,

Sasi