Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ms excel - pivot table

Posted on 2015-01-19
9
Medium Priority
?
132 Views
Last Modified: 2015-01-19
1) Data set = employee, location and date (mm/dd/yyyy) (3 fields)
2) Need only Year and not the whole date length.

How do I add just the Year to the pivot table (field list)  without changing  the data source  e.g. the Data set.


thanks!

bp
0
Comment
Question by:brianpowell
  • 4
  • 3
  • 2
9 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 40557977
Add the date field to the row area, right-click it and choose group, then Year.
0
 
LVL 18

Expert Comment

by:Simon
ID: 40557980
Either group the values in the pivot table (right click on one of the dates and select group by and then tick year in the dialog), or just format the pivot table field as "yyyy" if you don't want to group.
0
 
LVL 1

Author Comment

by:brianpowell
ID: 40558005
ok let me try this...
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Comment

by:brianpowell
ID: 40558011
ok side question - how do I get the versioning info and build data in ms excel......
0
 
LVL 1

Author Comment

by:brianpowell
ID: 40558020
I don't have the group by option on the right click!
0
 
LVL 18

Expert Comment

by:Simon
ID: 40558029
The right click is on the row area of the pivot table itself (not the pivot table field list dialog or the row labels section of that dialog).

You have to have data in the rows first.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 40558030
how do I get the versioning info and build data in ms excel

In 2010, File - Help.
0
 
LVL 18

Accepted Solution

by:
Simon earned 2000 total points
ID: 40558035
See this screenshot...Screenshot showing context menu for pivot table row field - Group Byand this one...Group by options for field that contains ONLY dates.
0
 
LVL 1

Author Comment

by:brianpowell
ID: 40558070
thank you for your time!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

569 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