Cross tab function

[wenyg]

Hi all,

  Would someone be able to help on how to transform my data looks like from pic 1 to pic 2? data is attached and made up for privacy purposes but in pic 3, it should be percentage of total cost. Thanks!

pic 1

pic 2

[Towers · Accepted solution]

Heres one way percentage of row view:  

 

Whole numbers view

@wenyg 

[wenyg]

Thanks,

  How do I add the % after the number under the percentage of row view?

[BS_THE_ANALYST]

@wenyg I don't want to take the credit, I'm adapting @Towers solution:

If you change that number I've pointed to above, it will show more decimal places i.e. 2.

We're using the Multi-Field tool here to change all the data types to string to include the % sign, as these will no longer be recognised as numbers. 

[wenyg]

thanks, it works now.

[BS_THE_ANALYST]

@wenyg Awesome!

[Shifty]

Nice solve, @Towers!