How to add two series on the same chart area in SSRS?
<p>I have made a chart like this from the Adventureworks database.</p>

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

<p>I had used the following table, querying from the Adventureworks database.</p>

<pre><code>Employee  | OrderYear  | OrderMonth |ProdCat    |    Sales
=============================================================
Shu Ito   |  2002      |  April     |Accessories| 565.222000
Shu Ito   |  2002      |  April     |Clothing   | 917.077000
Shu Ito   |  2002      |  April     |Components | 6149.999400
Shu Ito   |  2003      |  April     |Accessories| 288.859000
Shu Ito   |  2003      |  April     |Clothing   | 1661.651092
Shu Ito   |  2003      |  April     |Components | 11497.001600
Shu Ito   |  2004      |  April     |Accessories| 4960.536837
Shu Ito   |  2004      |  April     |Clothing   | 7947.791216
Shu Ito   |  2004      |  April     |Components | 29866.476000
</code></pre>

<p>The chart properties were like this.
<a href="https://i.stack.imgur.com/4X0LG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4X0LG.png" alt="enter image description here"></a></p>

<p>What I want is to add another column under each of the years (i.e. another series) that records the total sales of that year. (Total sales of Accessories, Clothing and Components)</p>

<p>I figured out that, I need to add a series using an expression, but I am not being able to write the expression.</p>