Hello All,
Have a query with regards to Pivot table.
I have below data where %Pax count is calculated month on month. How do I combine the data at different month level. For JAN to MAY and JUN - DEC. So data will have only two columns one is for JAN-MAY and another for JUN-DEC instead of 12 columns.
<colgroup><col><col span="13"></colgroup><tbody>
</tbody>
Regards,
Shan
Have a query with regards to Pivot table.
I have below data where %Pax count is calculated month on month. How do I combine the data at different month level. For JAN to MAY and JUN - DEC. So data will have only two columns one is for JAN-MAY and another for JUN-DEC instead of 12 columns.
Values | Month | ||||||||||||
Pax Count | Revenue | ||||||||||||
Fare Family | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan |
Freedom Economy | 1.20% | 0.74% | 0.53% | 0.71% | 0.14% | 0.35% | 0.80% | 0.99% | 0.56% | 0.43% | 0.29% | 2.24% | 644,768 |
Value Economy | 7.34% | 4.96% | 4.57% | 8.80% | 3.04% | 5.62% | 11.24% | 14.30% | 7.95% | 7.18% | 5.52% | 8.54% | 2,971,580 |
Saver Economy | 11.31% | 14.00% | 14.79% | 10.58% | 12.49% | 10.34% | 6.02% | 6.46% | 11.56% | 12.94% | 13.89% | 9.07% | 3,233,933 |
19.85% | 19.71% | 19.90% | 20.08% | 15.66% | 16.32% | 18.06% | 21.74% | 20.07% | 20.55% | 19.71% | 19.85% | 6,850,281 |
<colgroup><col><col span="13"></colgroup><tbody>
</tbody>
Regards,
Shan