Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached
Dimension:
Region
Code
Expressions:
=Sum(Amount)
=if(Region = 'b',Aggr(Above(Sum(Amount)),Code)/sum(Amount))
How is a and b repeating in table? Is there another dimension here?
yes another dimension also there
May be this (assuming there is only one other dimension):
Sum(Amount)/Above(Sum(Amount))
No its not working
Would you be able to share a sample?
Preparing examples for Upload - Reduction and Data Scrambling
See attached
Dimension:
Region
Code
Expressions:
=Sum(Amount)
=if(Region = 'b',Aggr(Above(Sum(Amount)),Code)/sum(Amount))
awseome