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!
Solved! Go to Solution.
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
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 |