Hi All, I'm trying to display prior 6 months in my cube view. For e.g. if my WF time is 2021, I want the CV to show last six months in 2020 (Jun - Dec) and so on. I tried using half year member filter, but it didn't work as it should. Any suggestions will be appreciated. Thank you, Mustafa

Probably lots of ways to build this, and it will vary based on you need (moving periods vs static periods). A few potential solutions for static periods:T#YearPrior1(|CVTime|)H2.MonthsT#PovPriorYearM6.AllNextInYearInclusiveThe documentation has good coverage on this area: Platform Guides > Design and Reference > Cube > Time Functions and Workflow References

How to grab Prior 6 months in CV | OneStream Community

Forum Discussion

Related Content

How to grab December of Last Year - or any particular month of Prior Year.

Prior/Current Month Dynamic Calculation

To Display all the prior months including the current month in the report

Member Expansion for Prior Half Year (months)

All Months in Prior Year based on Global Time