We would love to be able to pull data into a report where each row is a rolling 12-month period (i.e., February 2023 thru January 2024, next row would be March 2023 thru February 2024, etc.) with 2 columns - 1st column for the Total Sum of Dollars and 2nd column for the Total Sum of Days in Session - for each row. At the bottom of the report, it would have The Grand Total of both columns. This type of report would give at-a-glance information at any given month in the year. This is an example of a report I pulled for a one-year span. With the capability to have a rolling year in each row, this report would be 1st row July 2023 - June 2024 then columns to the right would still be total earned and # of days in session but for that year and each row would follow suit with the next row being August 2023 - July 2024 and so on.
... Mostrar más