Sorting Time Periods

[ChrisAHeathcote]

Hi All,

I would like to show the FY at the start of a time period.

This can be done using 'Show' functionality but I would like to use a dynamic filter that updates based on the current year.

Any thoughts?

Thanks,

Chris 

[JaredDolich · Accepted solution]

@ChrisAHeathcote 

You should be able to use the group position function.

For super advanced dynamic sorting of the hieararchy, there might be a creative way to use @Mark_W_Shemaria idea on identifying the groups first.

https://community.anaplan.com/t5/Best-Practices/Calculating-Levels-in-a-Hierarchy-for-Dashboard-Filt...

[ChrisAHeathcote]

@JaredDolich 

So simple yet I have never had the need to move them.

Thanks,

Chris 

[JaredDolich]

@ChrisAHeathcote 

It's amazing, isn't it? Always something new to learn. 

Can't wait to see January's upgrade. I read we're going to be able to pivot the grid without going into design.