SSRS: Dynamic difference between two columns in MATRIX

Question

I try to create (in SSRS) a summary of incomes in years and I'm stuck when I try to compare them.

e.g. of my table, where Rok = Years:

I have table like at image above where A and B are Expressions (sums of incomes). Columns are years from the SQL query, So 2020 will appear soon. I would like to divide 2019 vs 2018 but dynamically so if 2020 will appear, everything will calculate between 2020 and 2019. Do you know any solution for that ? Thanks in advance :)

Answer 1

First you need to have an individual filtered column group for each year. Second add in column outside group right, labelled as compare and Insert the following expression: =ReportItems!Rok.value - ReportItems!Rok1.value ( Rok and Rok1 are the Name available from Text Box Properties for each filtered column group)