Skip to Content

Sorting on Breaks with Totals

HI Experts,

I have a situation to apply sorting on totals , I am using break functionality, now if I put normal sorting then it only applies to the values not on the totals, I have removed sorting from manage breaks also tries with ranking but does not work.

Any idea on how to solve this?



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 19, 2018 at 11:26 AM

    follow these steps.

    Create "Sum" variable=sum([Actual]) in ([Brand])

    Drag Sum variable in the table and apply break on this column.

    After that apply break on Brand column.You will get the tables in descending order.

    Later hide the column Sum from the table.If you can not hide the measure variable (Sum) then create another variable dimension variable on top of Sum and drag in the table which you can hide.If still not work then for this particular column you can remove the border and keep back ground color white and white font.

    untitled.png (22.3 kB)
    Add comment
    10|10000 characters needed characters exceeded