--- title: Tips - How to convert your existing report to use Relative Periods description: Follow these steps to convert your existing report to an automated time report using Relative Periods. --- [Skip to content](https://fundamentals.theretailscore.com/knowledge/how-to-convert-your-existing-report-to-use-relative-period#main-content) English Show submenu for translations [Customer portal](https://fundamentals.theretailscore.com/support-client-view?hsLang=en) ![mousemat.png\]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png) Open main navigation Close main navigation - English Show submenu for translations - [Customer portal](https://fundamentals.theretailscore.com/support-client-view) - Go to theretailscore.com Go to theretailscore.com The Retail Score Fundamentals - There are no suggestions because the search field is empty. 1. [TRS Fundamentals](https://fundamentals.theretailscore.com/knowledge?hsLang=en) 2. [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en) 3. [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide) # Tips - How to convert your existing report to use Relative Periods ## Follow these steps to convert your existing report to an automated time report using Relative Periods. A report set up to use Relative Periods will always roll over to a relative point in time as it refreshes, removing the need to changing the calendar to a new time period as the weeks / months / years roll over. If you have already set up a report and you'd like to convert it to an automated time period so it rolls over as it is refreshed, you will need to ensure you have selected: 1. Calendar 2. Relative Period ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-20-2021-07-02-30-38-AM.png?width=401&name=image-png-Sep-20-2021-07-02-30-38-AM.png) Below example is a Weekly Location Sales report run on a Monday where  a distinct time period \[Week 49\] has been selected. ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-20-2021-07-26-32-20-AM.png?width=479&name=image-png-Sep-20-2021-07-26-32-20-AM.png) 1\. Add in Relative Period to the filter ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-20-2021-07-27-39-75-AM.png?width=414&name=image-png-Sep-20-2021-07-27-39-75-AM.png) 2\. Change the Calendar from the distinct time selection to an 'as @' relative time period. Consider it as setting the calendar to think it is a particular point in time relative to today. This may be 'last week' or 'yesterday' etc... These selections are found underneath the distinct calendar choices. In this example, I will change it to 'Last Week' ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-20-2021-07-29-33-26-AM.png?width=225&name=image-png-Sep-20-2021-07-29-33-26-AM.png) 3\. Now select the Relative Period This selection is the time period you want to analyse.  In this example I will change it to 'WTD'. ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-20-2021-07-30-35-63-AM.png?width=210&name=image-png-Sep-20-2021-07-30-35-63-AM.png) You can see that the report below has the same result as the first example with the distinct time selected. ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-20-2021-07-32-42-44-AM.png?width=447&name=image-png-Sep-20-2021-07-32-42-44-AM.png)       - [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started) - [02 How to Guide](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#03-get-help) - [tRS Insights Portal](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#01-getting-started) - [02 How To Guides](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#02-how-to-guides) - [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#main-content) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#03-get-help) - [tRS Modules](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#main-content) - [01 General Ledger](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#01-general-ledger) - [02 Traffic Counters](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#02-traffic-counters) - [04 Google Analytics](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#04-google-analytics) - [tRS Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#01-getting-started) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#03-get-help) - [tRS Case Studies](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#main-content) - [01 Analysis](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#01-analysis) - [tRS Archive Library](https://fundamentals.theretailscore.com/knowledge/trs-archive-library?hsLang=en) - [tRS Development Release Notes](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#main-content) - [Releases](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#releases) - [tRS Connect](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#main-content) - [01 About](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#01-about) - [02 Set Up](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#02-set-up) - [03 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#03-getting-started) - [tRS Planner](https://fundamentals.theretailscore.com/knowledge/trs-planner?hsLang=en) [![Chill listening crop-3](https://fundamentals.theretailscore.com/hs-fs/hubfs/tRS1-2.png?width=102&height=55&name=tRS1-2.png "Chill listening crop-3")](http://theretailscore.com?hsLang=en) theretailscore.com Help Center Copyright © 2026, the Retail Score