MS Excel 2003 - pivot table

P

Petka Nemcova

Hi everyone -

just wanted to ask you if you don't know by chance how can I create expanded
menu with "+" sign for "Date" field (it's a page field) in the pivot table. I
would like to group all individual dates by months and then if user click on
plus sign, all individual dates will show up for the particular month.

Thank you for any advice.
Petra
 
M

muddan madhu

try this

Assumed Date is in Col C and use helping column Col D "months" use
this formula
=Text(c1,"mmmm"), in Col D you will have months

now in pivot table wizard | layout | drag months field to Row | ok |
finish |

you will see both month and dates in row, double click months to
view / hide the dates.
 
Top