Does anyone know how to add hierarchy to the Accounting Period dimension so that it sorts properly? I'm getting periods in the correct year and quarter, but out of order.
i
Isaac M
04/18/2025, 8:32 PM
You'll probably have to seperate out the year and sort that first in a column or you can do something like 1 - January 2023, 2 - February 2023
j
Jason Haslow
04/21/2025, 1:10 PM
yep, thanks. I ended up with 07 2023, 08 2023, 09 2023. I saw a few enhancement requests for a sort key column in the hierarchy builder UI so maybe someday this won't be needed.