How do I add an additional Fiscal Year to my Microsoft Excel pivot table?

40 pts.
Tags:
Microsoft Excel
I have a Pivot Table in Excel that is already set to display Fiscal Year, Fiscal Quarter and Dates. What I need to know is how do I add an additional Fiscal year to the list of years available. It goes from 2010 through 2016, but I need to add data for 2017 now.


Software/Hardware used:
Excell 2013
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    If you can see the current values, you should be able to add the new dates manually. Are you looking for an external method for importing?
    132,840 pointsBadges:
    report
  • IkeWelsh
    Thanks Todd,

    Actually I didn't realize that the data that was being Copied and Pasted for October was the wrong format and did not have the correct info to pull from to derive the FY.
    I appreciate the response.

    IKE
    40 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: