Member Expansion for Prior Half Year (months)

[Mustafa_A]

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!

[ckattookaran]

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

[Mustafa_A]

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

[ChristianW · Accepted solution]

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

[Mustafa_A]

@ChristianW to rescue 🙂 

Thank you!  It worked