--- title: "Business Analytics - Show Prior Year" slug: "business-analytics-show-prior-year" description: "Add prior year data comparisons to Ad Hoc Reports by adding Fiscal Year as a column and filtering by year." updated: 2024-09-17T21:13:39Z published: 2024-09-17T21:13:39Z canonical: "docs.restaurant365.com/business-analytics-show-prior-year" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Business Analytics - Show Prior Year To show the comparison of any report over the prior year(s), you need to include **Fiscal Year** in the columns. In order to show Prior Year, the prior year **must** contain data, to show the prior year. Fiscal Day, Week, and Period will be the same each year. Use Fiscal Year, Week, or Period as the column. Then, **filter** the report for a specific Fiscal Period, Week, or Day, that should give you what you’re looking for. In the example above, the years 2022, 2023, and 2024 are selected. This shows each year as a column for each fiscal week. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-NJG2O9HA.png)