Skip to Content
0

Average Count of dates 1 year apart

Apr 28, 2017 at 03:20 PM

37

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Brian Dong Apr 28, 2017 at 08:43 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded