Skip to Content

Average Count of dates 1 year apart

Hello Experts,

I have a new report where I am having to look at the current month in one column and then show what the numbers were last year for said month. Is there a way to do this in 1 reports or do I need to have a subreport and then share formula? THis is what my report should look like:

report.png (5.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 28, 2017 at 08:43 PM

    Hi Matt,

    Cruurent vs. Previous reports are common. There are a couple of ways to do this but if you can get records for the current month and last year's then you can create a crosstab.

    This would be the most straight forward way.

    Brian

    Add comment
    10|10000 characters needed characters exceeded