Match or duplicate numbers

[SachinNataraj305]

Hi

Can you please help me with formula to match the number that are in same column

here is the table

Master	sub master	volume
AA	AA-00	2
AA	AA-01	0
AA	AA-02	0
BB	BB-00	3
BB	BB-01	0
CC	CC-00	1
CC	CC-01	0

Note: I prefer doing that in the UI and not in the script.

I want to match the volume of sub master AA-00 to AA-01 & AA-02 as they are same.

I tried this but didn't work, not sure if it is correct.

= match (if [ Master] = 1, [volume] ) [ volume]

so in the field dimension "volume" I have to input an expression to show or duplicate the volumes accordingly.

Thank you In advance

Sachin

[sasikanth]

HI, 

what is your expected output?

[SachinNataraj305]

Hi

the current table is as follows
Master sub master volume
AA AA-00 2
AA AA-01 0
AA AA-02 0
BB BB-00 3
BB BB-01 0
CC CC-00 1
CC CC-01 0
and the out put I would like to see is
Master sub master volume
AA AA-00 2
AA AA-01 2
AA AA-02 2
BB BB-00 3
BB BB-01 3
CC CC-00 1
CC CC-01 1
Note: I prefer doing that in the UI and not in the script.

[sasikanth]

try below expression

=if(Master=Above(Master), RangeSum(Above(sum(volume),1,2)),sum(volume))

Thanks, 

Sasikanth