How to divide row 1 by row 2 in Pivot or straight table

[#1]

Hi

Region	Amount	Result
a	20
b	2	10
a	30
b	3	10
a	40	5
b	8
a	60
b	4	15

i want to divide region  = a/b that means 20/2 = 10 result

please help on this

[sunny_talwar]

How is a and b repeating in table? Is there another dimension here?

[#3]

yes another dimension also there

[sunny_talwar]

May be this (assuming there is only one other dimension):

Sum(Amount)/Above(Sum(Amount))

[#5]

No its not working

[sunny_talwar]

Would you be able to share a sample?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[vinieme12 · Accepted solution]

See attached

Dimension:

Region

Code

Expressions:

=Sum(Amount)

=if(Region = 'b',Aggr(Above(Sum(Amount)),Code)/sum(Amount))

[#8]

awseome