Forum Discussion
Sorting when using calculation groups
Hi AlexanderNN
I am having the exact same issue with 2 calculation items : YTD and YTD%.
When I put the calculation group in a matrix (column), and select only one of the 2 items, I do not have any issue when sorting.
But once I select the 2 items (or any other item associate with one of those 2 items => I tried with a dummy item = 0), the sorting is not working properly. Sorting seems random.
I tried to do the same thing with 2 other calculated items => CY (which is simply "selectedmeasure()") and CY%. There is no problem with those 2, the sorting is good even when I selected both items.
In fact, the sorting that seems random with the YTD items, is in fact the sorting of the CY => as if when selecting 2 items with YTD, the sorting goes by default to the initial "selectedmeasure()".
The issue seems to be related to the YTD calculation, but I can not figure out why.
I looked for the same problem in many forums, but couldn't find anyone encountering the same issue...except for you.
Did you finally find where the problem was coming from ? How did you resolve it ?
Would be great if we could resolve this.
Regards