Results 1 to 2 of 2

Thread: Grouping then expanding/collapsing

  1. #1

    Grouping then expanding/collapsing

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi friends,

    I have a set of data, from which I have created a PivotTable and that's all fine and dandy. The original data has a Date field, which lists each individual date (DD/MM/YYY) for each particular record and it has already been sorted in ascending order.

    Onto the PivotTable, I have grouped them by month then by quarter (Excel does this automatically after I have selected them to be grouped). However, right now, how can I expand the individual months within the quarter (to see the individual dates within that particular month)?

    It currently looks like this:
    (see attached file as I am unable to post links)

    Please let me know how I would be able to go about expanding it in order to view the individual dates for the particular month(s).

    Thank you!

    (Using Excel 2013)
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	PTexcel.png 
Views:	17 
Size:	3.4 KB 
ID:	2537  
    Last edited by Restricted; 2014-08-10 at 02:53 AM. Reason: add info

  2. #2
    Acolyte Weazel's Avatar
    Join Date
    Jul 2014
    Excel Version
    try grouping by Days, Months, and Quarters instead of just Months and Quarters

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts