Forum Discussion
The order in Matrix table
- Anonymous1 year ago
Hi brankocareer ,
Thanks for reaching out to us.
In a table visual, you can sort by combination, for example, first by Rollup Account Category, then fixed, and then by Amount.
But, in a matrix, you can't do that, it's by design. You can either combine the Rollup Account Category and Rollup in the row to sort or sort the amount separately.
Here, the workaround is: go to data view, sort Rollup by Amount.
Of course, this workaround may also have limitations, which require further testing, but for now it is perfect.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi brankocareer ,
Thanks for reaching out to us.
In a table visual, you can sort by combination, for example, first by Rollup Account Category, then fixed, and then by Amount.
But, in a matrix, you can't do that, it's by design. You can either combine the Rollup Account Category and Rollup in the row to sort or sort the amount separately.
Here, the workaround is: go to data view, sort Rollup by Amount.
Of course, this workaround may also have limitations, which require further testing, but for now it is perfect.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly