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

from column header to total row

chiragpatel_1
8 - Asteroid

Hi,

 

Cant seem to get this right using cross tab.

 

What i would like is the total core and total mp column to appear as one row, so row number 5 would be added and the total core figure would be placed under the 'Core' column and same for total mp figure. Thank you!

 

chiragpatel_1_0-1670322808288.png

 

3 REPLIES 3
ShankerV
17 - Castor

Hi @chiragpatel_1 

 

Can you please also paste the desired output.

 

In addition please, also share the input in text format where I can use in the workflow to build.

 

Many thanks

Shanker V

chiragpatel_1
8 - Asteroid

desired output:

 

chiragpatel_1_0-1670323406235.png

 

Length of HireCore% of  Core TotalMP% of  MP TotalTotal CoreTotal MP
<3 months170217438189179.412.744780501494572.3
3-6 months146778632.8143295.59.644780501494572.3
6-12 months837459.718.7574981.238.544780501494572.3
>12 months470630.410.5587116.239.344780501494572.3

 

binuacs
20 - Arcturus

@chiragpatel_1 One way of doing this

binuacs_1-1670325061932.png

 

 

Labels