Could you please post an example and explain how would % calculation work? Thanks

Hi Paola,

Assume I created the following Table in the Pivot View.

Name FirstStep SecondStep ThirdStep Total
John 3 17 7 27
Maria 14 12 6 32
George 5 5 8 18
Stella 21 3 4 28

Eventually I want to convert the numerical values in % based on the rows and not the columns like below.

Name FirstStep SecondStep ThirdStep Total
John 11% 63% 26% 100%
Maria 44% 38% 19% 100%
George 28% 28% 44% 100%
Stella 75% 11% 14% 100%

It might be easier if you add % fields with formulas and format them as %:
[FirstStep]
/
([FirstStep]+[SecondStep]+[ThirdStep])

In case of multiple records with the same [Name]:

SUBSET_SUM([FirstStep], subset([Name]))
/
(SUBSET_SUM([FirstStep], subset([Name]))+SUBSET_SUM([SecondStep], subset([Name]))+SUBSET_SUM([ThirdStep], subset([Name])))

Thanks a lot Paola.