from column header to total row

[chiragpatel_1]

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!

[ShankerV]

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]

desired output:

Length of Hire	Core	% of  Core Total	MP	% of  MP Total	Total Core	Total MP
<3 months	1702174	38	189179.4	12.7	4478050	1494572.3
3-6 months	1467786	32.8	143295.5	9.6	4478050	1494572.3
6-12 months	837459.7	18.7	574981.2	38.5	4478050	1494572.3
>12 months	470630.4	10.5	587116.2	39.3	4478050	1494572.3

[binuacs · Accepted solution]

@chiragpatel_1 One way of doing this