How to add column labels in pivot table

Hi Guys,

In my pivot table my column label is month like feb 1- march 31. i want to add up all the qty from feb1-28 and next column total for march 1-31. how will i do it? please see attached file for clearer picture.

thank you.

Here are the steps
1. Add a helper column showing Month Text Just as I have done in Column H
2. Now insert a Pivot Table
3. Put Fields in there required sections in the Pivot table Field List Window just as I have done .
4. Now Select the Row Lable column and Uncheck the Subtotal for Material field option. That’s it.

Check the attached file:-

Hi Thanks for that reply, i was thinking about that then, but i have seen a file where there is no helper column I was wondering then how it was done.

Hi BusyGurl,
I have managed to do this, Excel inbuilt help has enlightened me.

Steps:-
Click any date in the Column Lables
Click Pivot table options tab on the Ribbon.
In the Options Table, Click Group Field option.
Click Months then click Ok. Thats it.

check the attached file:-

Hi Vikas_Gautam,

wow thank u so much.... really need to explore more....