Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Cross tab function

wenyg
8 - Asteroid

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

wenyg_0-1678814035198.png

pic 2

wenyg_1-1678814053588.png

 

6 REPLIES 6
Towers
11 - Bolide

Heres one way percentage of row view:  

Towers_0-1678815087601.png 

Whole numbers view

Towers_0-1678815173599.png

@wenyg 

 

wenyg
8 - Asteroid

Thanks,

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

BS_THE_ANALYST
13 - Pulsar

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

BS_THE_ANALYST_1-1678816814979.png

 

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
8 - Asteroid

thanks, it works now.

BS_THE_ANALYST
13 - Pulsar

@wenyg Awesome!

 

Shifty
12 - Quasar

Nice solve, @Towers

Labels