Hi I have records in a database something like this: Area Gender Year Percentage France Male 2010 56.8 France Female 2010 55.3 France All 2010 56.1 Neighbours Male 2010 48.5 Eurpoe Male 2010 52.2 World Male 2010 46.5 And I am using a matrix, grouping columns on Year and Gender and Rows on Area to report like this: Year 2010 Year 2009 Year 2008 Male female All Male Female All Male Female All Area France 56.8 55.3 56.1 etc etc Neigbours 48.5 Europe 58.2 World 46.5 I would now like to add 3 rows below the 4 rows produced by the matrix to show the difference between each of the country and its neighbours, europe and World for all column groupings e.g. France - Neighbours +8.3 France - Eurpoe -1.4 France - World +12.3 Is there an easy way to achiev this? Many thanks for your help Retrov

Hi, Yes. We can achieve this by using conditional aggregate calculations. For example, in order to calculate “France – Neighbours”, please refer to the steps below: 1. Insert a group footer for the row group Area. 2. In the footer row, specify the expression like =Sum(IIf(Fields!Area.Value="France",Fields!Percentage.Value,0))-Sum(IIf(Fields!Area.Value="Neighbours",Fields!Percentage.Value,0)) Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.