Add variance in the rows of table
<p>I've a SSRS report which should look like below,</p>

<pre><code>--------------------------------
Year Product Total customers
--------------------------------
2015 prd1      100
     prd2       50
     prd3       60

2014 prd1       80
     prd2       60
     prd3       60

Varience
    Prd1        20
    Prd2       -10
    Prd3         0
</code></pre>

<p>I've done the year wise grouping and the data mapping. But I'm not sure how to add variance(between 2015-2014) in each row based on the each product of the year</p>

<h2>Update:</h2>

<p>My dataset looks like this</p>

<pre><code>Year    CategoryId  CategoryDesc    TotalCustomerCount  
2013    Prd1        Testproduct     100
2013    Prd2        Testprod2       50
2013    Prd3        Tesrprod3       45
2014    Prd1        Testproduct     80
2014    Prd2        Testprod2       60
</code></pre>

<p>You can see that some products may miss out in a year. </p>

<p><strong>Note</strong>: The dataset is created from a Dimesional cube and not from SQL queries.</p>