what is Year To Go in Time?
@Pavan417
Think of YTG as the younger brother of YTD. YTD shows your totals up to a specific month-end or quarter-end. YTG shows the total left in the year.
It shows you the data that gets populated for all the periods that are left in a particular year starting from Current Period of the model timescale. For Example if your model calendar is Jan - Dec and your current period is June your YTG column will show you the data that is from July-Dec and YTD shows you the data that is from Jan- Jun
Hope that answers your question
Misbah
If we go down lowest descendants for 2 hierarchies something like this {Descendants([Planning Org].[Planning Org].[ALL].[AllMember],255,LEAVES)} then the queries timeout what is the best way to use lowest decendants so it doesnt scan the whole hierarchy
Hi! In London it was mentioned, any update on this?
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
