Forum Discussion
Calculation group not displaying in order
Super UserHi Stacey_Griffeth
I haven't tried it yet, but I guess that the logic is the same as on calculated groups that are created with a tabular editor.
So you can try this guide :
https://www.youtube.com/watch?v=mLWRfKIgYvk
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983 thank you for that link, that was definitely something I did not know! Unfortunately, it is not quite the same as the issue I'm facing. That video shows us how to set which column to sort by within the calculation group. The issue I'm having is with the order of the columns within the calculation group. I've followed Microsoft's guide on creating the groups and setting the order of the columns within the group via the model view. But when applying the calculation group to a matrix, the order I set is not reflected and, instead, it is in alphabetic order. That might be fine for some uses, but when they are all time intelligence, I want it to be something like MTD, QTD, YTD, PY MTD, PY QTD, PY YTD... instead it's coming out MTD, PY MTD, PY QTD, PY YTD, QTD, YTD. I'm thinking it's some sort of bug.