Member Expansion for Prior Half Year (months)

Hi All,

How do I make my Cube View display prior2 year (2020), but only the last six months. Any suggestions will be appreciated. Thank you!

Best answer by ChristianW

This should work: T#|CVYearPrior2|H2.base

Member

Did you try using any time substitution variables and see if those work for you?

Contributor

No, but I'll look in to it more. Thank you!

Answer

Advisor

This should work: T#|CVYearPrior2|H2.base

Contributor

ChristianW to rescue 🙂

Thank you! It worked

Sign up