calculate percentages of multiple columns

[Fran2]

Hi all, 

how do I calculate percentages of multiple columns? 

This is the input:

a	b	c	sum_abc
10	21	12	43
10	5	6	21
1	2	6	9

And this is the desired output:

b%	c%	d%
23.26	48.84	27.91
47.62	23.81	28.57
11.11	22.22	66.67

Thanks in advance!

[Felipe_Ribeir0 · Accepted solution]

Hi @Fran2 

You can use the multi field formula for that 

[BS_THE_ANALYST]

A nice way using transpose+crosstab I learned last week! :-). @Fran2