Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently, I have one straight table like below:
Asset Class | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD Revenue |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
aa | |||||||||||||
bb | |||||||||||||
cc | |||||||||||||
dd |
The column from Jan ~ Dec will be shown when it reach the corresponding month. e.g. Currently month is June, it will show as below.
Asset Class | Jan | Feb | Mar | Apr | May | YTD Revenue |
---|---|---|---|---|---|---|
aa | ||||||
bb | ||||||
cc | ||||||
dd |
And I want to sorted by YTD Revenue always. The sort priority will change automatically when have more month to shown on left of YTD Revenue. How to keep highest priority for YTD Revenue no matter we have how many monthes to show?
Hello Alex, Please add this in your YTD?
Month = {'$('<=' & <=Max(Month))'}