Does anyone know how to add hierarchy to the Accou...
# nsaw
j
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
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
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.
1