Excel 2013 Pivot Query

[shansakhi]

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.

	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

 

[Worf]

Hello

You can perform the calculation on the source data and pivot it, or use calculated fields/items within the existing pivot table, hiding the unwanted columns:

http://www.contextures.com/calculatedfieldcalculateditem.html

 

[shansakhi]

Thank you. I have used the Calculated item option. Its given a desired output.

 

[Worf]

You are welcome and thanks for the feedback.