from column header to total row

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!

Workflow

Accepted answers

binu_acs

@chiragpatel_1 One way of doing this

Total_1206.yxmd

All comments

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

binu_acs

@chiragpatel_1 One way of doing this

Total_1206.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335