how to seperate one matrix into showing data for this year and previous
<p>I have a report where my source gives me data for multiple years. In my report data I have 2 parameters- 1 is Brand and 2 is Year. I have made one matrix which has 5 columns in it with a row group. I want to define the column in such a manner where i pass a year to the parameter say 2016, but it automatically returns me data for that and previous year. </p>

<p>I tried using expression in the column group header:</p>

<pre><code>=MAX(Parameters!Year.Value) OR MAX(Parameter!Year.Value) - 1
</code></pre>

<p>and</p>

<pre><code>=MAX(Parameters!Year.Value) OR MAX(Parameter!Year.Value) - 1
</code></pre>

<p>Image of what I currently have:</p>

<p><a href="https://i.stack.imgur.com/umqNW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/umqNW.png" alt="enter image description here"></a></p>

<p>What I want to see it as:</p>

<p><a href="https://i.stack.imgur.com/HBOTo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HBOTo.png" alt="enter image description here"></a></p>

<p>EDIT:</p>

<p>Dataset Sample:</p>

<p><a href="https://i.stack.imgur.com/OTGUO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OTGUO.png" alt="enter image description here"></a></p>

<p><a href="https://i.stack.imgur.com/DVvIA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DVvIA.png" alt="enter image description here"></a></p>