Solved

excel pivot columns to cross years

Posted on 2014-03-22
2
211 Views
Last Modified: 2014-03-28
I have an excel table with an invoice date field. I would like to format this field or another using this field in a MMYY format. The purpose being to create a slicer for columns of data to cross years. example: select 1112; 1212; 0113; 0213 would create a pivot with cumulated data with 4 columns spanning 1112 to 0213. Is this possible?
0
Comment
Question by:actsoft
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
usachrisk1983 earned 500 total points
ID: 39948057
If it's in date format in the cell, you can create a second column that has the formula:

=Year(A1) & "-" & Month(A1)

Open in new window


You can pull out the "-" if you don't want the hyphen there, and you'll want to replace A1 with the cell you're trying to reformat.
0
 

Author Closing Comment

by:actsoft
ID: 39961201
Thanks, I was trying to make it much more complicated than necessary.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
kendo spreadsheet 2 343
CUT & PASTE VALUES IN EXCEL USING MACRO -- SPECIFIC CELLS 27 93
If condition and Date Ranges 13 49
Excel IF statement 4 23
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.

733 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