title: Show a specific value in last in SSRS
body: <p><a href="https://i.stack.imgur.com/y0tsV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/y0tsV.png" alt="enter image description here" /></a></p>
  <p>Here, I want the &quot;other brands&quot; should be in the last row in that group always.</p>
  <p>I use the below case to show the Brand column</p>
  <pre><code>CASE 
      WHEN INFO.OTHERID = 1 THEN INFO.BRAND 
      WHEN INFO.OTHERID = 0 THEN 'Other Brands'
      ELSE '-' 
  END AS BRANDS
  </code></pre>