Matrix for Media

Monarch - Multi Year Sales History Report Overview

The Multi-Year Sales History Report allows you to see your booked dollar across multiple time periods so that you can spot trends in business. 

To create the Multi-Year Sales History report, please follow the below instructions:

  1. Please navigate to Reports on the menu bar.
  2. Click the Revenue tab.
  3. Click the Multi-Year Sales History Report link.

On the Options screen, you will be presented with the below options to build your report.

  1. Hierarchy Selection - in this drop-down you may select the attribute(s) that are to be on the report
  2. View By Selection - in the toggle select the view of Month or Quarter. In the drop-down next to the toggle, you may select which years or quarters you would like to review.
  3. Years Selection - in this drop-down you may select what year(s) the report will show
  4. Calendar Selection - in this drop-down you may select what calendar type the report will utilize
  5. Sort By Selection - in this drop-down you may select the sorting of the data within the report
  6. Run Button - once all options have been selected, clicking the Run button will run the report

Clicking the Filters tab will allow you to select or not select various data points or groups within the report.

Once the report is run, the screen will display the report based on the Options and Filters selected. A view like the one below will appear.

  1. Show Option-clicking this button will show the Options and Filters dialog to edit the report and allow you to re-run the report
  2. Hide Chart - clicking this button will remove the chart from the view
  3. Chart Field - the report will display a line chart showing the trending over the time frame that was selected
  4. Favorite Icon - clicking the Star icon will allow you to save the report as a favorite. Once saved as a favorite, the report can be shared with other users
  5. Download - in the drop-down a user can select to export the data in either a .csv format or Microsoft Excel format. Clicking the icon next to the drop-down will download the report in the selected format
  6. Report Data - the table at the bottom of the screen is the data from the report. The Multi-Year Sales History Report is formatted so that the hierarchy is on the far left, followed by the years, the total for the line, and then the dollar value for each time frame unit (month or quarter) that was selected

Did you find it helpful? Yes No