asked on December 14, 2022
Hello,
When using measures with aggregation we're unable to sort the pivot by them.
For reference we are using a Microsoft analysis services data cube.
Kind regards,
Craig Button
⋅ December 14, 2022
Hello, Craig!
Thank you for contacting us.
Kindly note that we haven't managed to reproduce the described behavior on our side.
We have prepared a JSFiddle example with our multidimensional sample cube: https://jsfiddle.net/flexmonster/nxjvd1zc/.
In this example, the values are sorted initially by the measure with percentofcolumn aggregation in the slice.sorting. The example also shows how the sorting can be changed using the sortValues() API call.
Could you please look through the provided example and modify it to make the case reproducible?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ December 21, 2022
Hello, Craig!
Hope you are doing well.
Our team is wondering if you had a chance to look through our example of sorting by measures using our multidimensional cube.
Could you please let us know if it was helpful?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ December 28, 2022
Hello, Craig!
Hope you are having a great week.
Just checking in to ask if our example of sorting by measures using a multidimensional cube was helpful.
Looking forward to hearing your feedback.
Regards,
Solomiia
