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

How do I dynamically show Q4 from prior year as a comparison column if I choose Q1 in my POV?

Accepted answer


In Reports, what is the best way to dynamically show the prior period chosen in the POV. If Year Total is chosen, only the Year would change.

Content (required):

Period offset works for base members but not the quarters. Relative works at same level, but then the year doesn't change. Am I missing a function or some sort of combination of these? The best that I can come up with with Relative with Prompt function for the "Vs Year". Any suggestions? Is there a way to write boolean member selection logic?

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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