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