Skip to main content
A
Avatar-Roku
Newcomer
February 4, 2022
Solved

Member Expansion for Prior Half Year (months)

  • February 4, 2022
  • 2 replies
  • 0 views

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!

Mustafa_A_0-1643987661616.png

 

Best answer by ChristianW

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

2 replies

C
ckattookaran
Newcomer
February 4, 2022

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

A
Avatar-RokuAuthor
Newcomer
February 4, 2022

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

C
OneStream Employee
ChristianWOneStream EmployeeAnswer
OneStream Employee
February 4, 2022

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

    A
    Avatar-RokuAuthor
    Newcomer
    February 4, 2022

    ChristianW to rescue 🙂 

     

    Thank you!  It worked 

    Terms & ConditionsAccessibility statement