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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel 2003 - pivot tables 0
Pivot table 0
Excel 2007 pivot table: select multiple data easier 0
pivot table data 2
VLOOKUP a Pivot Table Filter 0
Adding Same Field 2x in an Excel 2007 Pivot Table 0
Slicers and Calculated Items in Pivot Table 2
Expanding Single Items In Large Pivot Tables 1

Top