Sort Column Group in SSRS Matrix
<p>I created a report using matrix and I want to add interactive sort for it's column group. When I add interactive sort for <code>Sales Amount</code> it does not work.</p>
<p>This is my first look of my report:</p>
<p><a href="https://i.stack.imgur.com/GgUMk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GgUMk.png" alt="enter image description here" /></a></p>
<p>and when I click on sort arrows it turn to this one:</p>
<p><a href="https://i.stack.imgur.com/Cw2lC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Cw2lC.png" alt="enter image description here" /></a></p>
<p>nothing happened an the value of Australia changed!!!</p>
<p>But I do it with Table and it works good.</p>
<p>How I can sort such these columns in column groups in matrix?</p>
<p>thanks</p>