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...
Forum Discussion
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.
Thank you for this! We have our set up so that it does have to run based on POV, but I will keep this option for future projects.