We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
13 - Pulsar

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
17 - Castor

@chiragpatel_1 One way of doing this

binuacs_1-1670325061932.png

 

 

Labels