Solved
How to grab Prior 6 months in CV
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 memb...
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.Months
T#PovPriorYearM6.AllNextInYearInclusive
The documentation has good coverage on this area: Platform Guides > Design and Reference > Cube > Time Functions and Workflow References
