Position of Totals

ankit_cheeni

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?

ankit_cheeni

Hi @BrunoRodriguez , sort doesn't work with nested dimensions does it? I had to select some items manually for this to work.

BrunoRodriguez

Hello @ankit_cheeni ,

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

Cheers!

BrunoRodriguez

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!