Forum Discussion

brankocareer's avatar
brankocareer
Helper I
1 year ago
Solved

The order in Matrix table

Hi, In the matrix table , there are 2 items under "Rows" : [Rollup Account Category ] and [Rollup], my goal is: 1. The order of [Rollup Account Category] is fixed. 2. The order of [Rollup]...
  • Anonymous's avatar
    Anonymous
    1 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