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
aricgresko's avatar
aricgresko
Contributor III
3 years ago

Try this setup below if you want to make the report more dynamic for the users in terms of selecting the period and selecting the view dimension, unless your report requires it to be run based on user POV.

Note: |!ParamMonth!| is my parameter to select the month for the first column.

          |!ParamView!| is my parameter to let the user select Periodic, MTD, QTD, or YTD.