Computing calculated row

[Aria_S]

Hi,

I am trying to calculate only ONE row based on 2 rows of my data set:

Input:

Object	Balance 1	Balance 2	Balance 3
A	1000	2000	3000
B	200	600	700
C	400	500	400

Output:

Object	Balance 1	Balance 2	Balance 3
A	1000	2000	3000
B	200	600	700
C	400	500	400
D%	80%	70%	43%

Where D% = ((Balance(A)-Balance(B)) / Balance(A))*100

Is there a way to calculate only one row based on the formula above?

Thank you!

[echuong1 · Accepted solution]

You can "pivot" your data and then do the calculation. After that, you can "pivot" the data back.