Sorting Time Periods

ChrisHeathcote
Community Boss

Sorting Time Periods

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 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Sorting Time Periods

@ChrisHeathcote 

You should be able to use the group position function.

TotalPosition1.pngtotalPosition2.png

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...

 


Jared Dolich

View solution in original post

3 REPLIES 3
JaredDolich
Moderator

Re: Sorting Time Periods

@ChrisHeathcote 

You should be able to use the group position function.

TotalPosition1.pngtotalPosition2.png

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...

 


Jared Dolich

View solution in original post

ChrisHeathcote
Community Boss

Re: Sorting Time Periods

@JaredDolich 

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

Thanks,

Chris 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
JaredDolich
Moderator

Re: Sorting Time Periods

@ChrisHeathcote 

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.


Jared Dolich