Results 1 to 2 of 2
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rolling 12 Months - Pivot Table

    Good morning All,

    I got some really good (and speedy) answers with my last question. Hopefully this one will prove as easy to answer ...

    I know how to do YTD but how do I get a pivot table to show a rolling 12 months figure?

    See really simple attachment to illustrate.
    Attached Files Attached Files
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rolling 12 Months - Pivot Table

    For a quick fix I included a column in the actual data to incorporate a Rolling 12 Month value (where applicable). Off hand I can see no easy way creating a formula for a calculated field to give a rolling 12 mnths in the Pivot Table, as it would require spanning 2 years in your case.

    I am attaching the file to show what I mean.

    Regards,

    Andrew C
    Attached Files Attached Files

Posting Permissions

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