Hi all!
I'm using CR10 with an Oracle db.
I'm havning a problem figuring out how to get this done. I am trying to pull a small amount of data that looks in the previous 4 rolling quarters, excluding the current quarter. I only need the previous 4 full quarters data, no partial quarters. The field that I would use is a standard date field to determine the quarters.
I guess what it would need to do is start at the end of the previous quarter and then go back 12 months.
I would like to use this formula in the selection criteria if I could.
Any ideas?
Thanks in advance!
I'm using CR10 with an Oracle db.
I'm havning a problem figuring out how to get this done. I am trying to pull a small amount of data that looks in the previous 4 rolling quarters, excluding the current quarter. I only need the previous 4 full quarters data, no partial quarters. The field that I would use is a standard date field to determine the quarters.
I guess what it would need to do is start at the end of the previous quarter and then go back 12 months.
I would like to use this formula in the selection criteria if I could.
Any ideas?
Thanks in advance!