Forum Discussion

DamarisE's avatar
DamarisE
New Contributor II
3 years ago

Prior Year, YTD Cube View Columns

Hi All, I am creating a cube view with a 'Current Year' column and a 'Prior Year' column based on the POV (this company has an August close fiscal year).  These columns work if I am viewing full ye...
Cube View
DamarisE's avatar
DamarisE
New Contributor II
3 years ago

Hi everyone,  My team and I figured this out.  We ended up using: T#YearPrior1(|CVTime|)Period(|CVTime|) to pull current period prior year data.  Curious as to why this is not in the design document, this is a standard reporting requirement.

Thanks,

Damaris