View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default MS Excel 2003 - pivot table

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.



On Feb 12, 3:28*pm, Petka Nemcova
wrote:
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