% Calculation

[BRRLL99]

Hi Team,

I have following dataset

DATA	SS	RR	CC	TOTAL
A	10	10	20	40
B	15	20	30	65

Expected output:

DATA	SS	RR	CC	TOTAL
A	10	10	20	40
A ( %)	25%	25%	50%
B	15	20	30	65
B ( %)	23%	31%	46%

While using formula tool I would like to have total's should be picked dynamically.

[FinnCharlton]

Hi @BRRLL99 , you can do this with some creative cross-tabbing and transposing:

Hope this helps!

[BRRLL99]

is it possible to build same workflow dynamically with less tools

[Christina_H]

How about this?

[BRRLL99]

IF I'm using Round in my original data set I have percentage values less than 1

like 0.81 or 0.99 etc it is showing as "0"

and I would like to have percentage sign shown instead of

expected output:

A --   8% ,  0.86%, 15% etc

B --   0.67% , 5.4% etc

[BRRLL99]

I'm looking for decimal places 

ex: instead of 52% it should be 51.6% etc

[Christina_H · Accepted solution]

Updated

[binuacs · Accepted solution]

@BRRLL99 Another method