Solved

Pivot table in Excel 2010 displaying dates by individual days, but need to be month/period

Posted on 2013-11-20
2
512 Views
Last Modified: 2013-11-20
I am using Excel 2010.

I have a pivot table that displays the dates as individual days, but I need for it to display them as months or periods...how do I do this?
0
Comment
Question by:broadcastwarehouse
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39662655
Right click on the date column in the PT and select Group... then you can select the periods, etc..
0
 

Author Closing Comment

by:broadcastwarehouse
ID: 39662759
Quick response and was the perfect solution to my problem!

Thanks :)
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now