You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Match function for CurrentPOV - 1

I am using the match function in the period dimension, where if Current POV is Aug i get YTD_Aug member through match function in another row.

I have given an example below. I am able to achieve till Row 3. How do i build the report to get to Row 4. I do not see the option in match function to take current pov -1 instead of Current POV. I also want to get another row which matches the member with Current POV - 1.

Row 1 - Current POV

Row2 - Current POV - 1

Row3 - Match YTD_with Current POV

Row4 - Match YTD_with Current POV - 1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!