# Create a rolling trailing 12 month summary

**URL:** <https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787>\
**Category:** Ask the Community\
**Created:** [January 28, 2021, 10:20pm UTC](https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787 "2021-01-28T22:20:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![wpratt](https://avatars.discourse-cdn.com/v4/letter/w/2acd7d/32.png) [@wpratt](https://pug.phocassoftware.com/u/wpratt)\
**Post date:** [January 28, 2021, 10:20pm UTC](https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787/1 "2021-01-28T22:20:11Z")

</div>

I’m trying to create something that seems pretty easy (in theory), but am having a hard time figuring out how to do it.

I am currently showing some sales data on a line chart. The sales peak in 2Q and 3Q and fairly flat in 1Q and 4Q. In order to smooth out the lines, my boss has asked to see the data on rolling trailing 12 month basis; so that the data point for January 2021 would be the sum of (Feb 2020 - Jan 21), February 2021 would be the sum of (Mar 2020 - Feb 2021), etc. I’m thinking it would be a custom period, but I’m having trouble setting it up. Any guidance is appreciated.

---

<div class="post-metadata">

**Author:** ![tim.janes](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/tim.janes/32/361_2.png) [@tim.janes](https://pug.phocassoftware.com/u/tim.janes)\
**Post date:** [January 29, 2021, 4:29pm UTC](https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787/2 "2021-01-29T16:29:56Z")

</div>

Hi @wpratt ,

I would suggest adding a Rolling 12 Month period in as a Defined Period on the database you’re using. You would need to be an administrator in order to do so. If you are, you can go to Administration → Databases. Click into the database you want to add the period to. Go to the “Defined Periods” tab. Click the “Add” button, then select the “Rolling 12 Months” period.

See how that goes!  
Tim

---

<div class="post-metadata">

**Author:** ![wpratt](https://avatars.discourse-cdn.com/v4/letter/w/2acd7d/32.png) [@wpratt](https://pug.phocassoftware.com/u/wpratt)\
**Post date:** [January 29, 2021, 4:44pm UTC](https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787/3 "2021-01-29T16:44:13Z")

</div>

Very cool. Thanks Tim. I’ve only been with the company a few weeks so I’m not sure what level of admin access I actually have, but I’ll find out. Appreciate the help.

---

<div class="post-metadata">

**Author:** ![nicolas.servouse](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/nicolas.servouse/32/50_2.png) [@nicolas.servouse](https://pug.phocassoftware.com/u/nicolas.servouse)\
**Post date:** [February 2, 2021, 1:40pm UTC](https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787/4 "2021-02-02T13:40:18Z")

</div>

Hi @wpratt , you should also be able to use the Moving mode in Phocas  
Click on the mode button (typically displaying “Period” and change to “Moving”. This will give you a 12 month rolling.  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/2X/a/a340eabf3a1451952442f6c20f57f06951b501ff.png)

---

<div class="post-metadata">

**Author:** ![wpratt](https://avatars.discourse-cdn.com/v4/letter/w/2acd7d/32.png) [@wpratt](https://pug.phocassoftware.com/u/wpratt)\
**Post date:** [February 2, 2021, 11:29pm UTC](https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787/5 "2021-02-02T23:29:10Z")

</div>

Fantastic! I knew there had to be a pain free way to accomplish this. Thank you for pointing it out for me.

---

<div class="post-metadata">

**Author:** ![wpratt](https://avatars.discourse-cdn.com/v4/letter/w/2acd7d/32.png) [@wpratt](https://pug.phocassoftware.com/u/wpratt)\
**Post date:** [February 11, 2021, 10:59pm UTC](https://pug.phocassoftware.com/t/create-a-rolling-trailing-12-month-summary/1787/7 "2021-02-11T22:59:48Z")

</div>

Thank you!