Example Date:
Records (strings): R1213, R1214 R1215,R1214, … (Several copies, but only need the distinct)
Periods: Weeks, Starting on Friday.
Goal: To compare the prior years count to this years. For example, if we had 100 Records Last year and 125 this year.
There would be two calculated fields, one of current year, one of prior year.
This is going in a PivotTable as a value.
Hi @ScottP
I have found the following article quite useful when working on Period Over Period computations.
Regards,
Giri
Hi @ScottP,
It’s been awhile since we last heard from you, did you have any additional questions or did one of the solutions provided above help with your case?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
This did help with my question. Thank you Brett.