Position of Totals

ankit_cheeni
ankit_cheeni
in Modeling

I have two nested dimensions, A & B, in rows and time and line items being in columns. I want to show time totals (All Period and Qtr) first and then the months but even if I sort, Anaplan defaults back to its general time sequence the moment I put Line Items in Columns. I don't want to manually select and then show time. Is there a better way to do this?

Tagged:

Best Answer

Comments

  • BrunoRodriguez
    BrunoRodriguez

    Hello @ankit_cheeni ,

    What about using sort? Could you try to apply it to the time?

    Cheers!

  • BrunoRodriguez
    BrunoRodriguez
    edited May 4

    Hello @ankit_cheeni

    You are right. If you try to sort with nested dimensions it says "Sorting an axis with nested dimensions is not supported.".

    What you can do is create a flat list with the concatenation of the dimensions and sort using the extracts of the concatenated code through find items

    Cheers!

Categories