SSRS Matrix compare column values

I have been struggling to compare column values in a SSRS matrix (pivot table), but finally found a way around it.

My solution is rather simple, but it works.

Here is a simple example of the Matrix:

ExampleM1M2M3
Cust 1101510
Cust 2131215
Cust 3202227

For example, I would like to compare the M2 value with M1 (15 vs 10) etc.

ExampleM1d1M2d2M3d3
Cust 110015510-5
Cust 213012-1153
Cust 3200222275

My initial thought was to use the ‘Previous’ function, but that did not seem to work, as it showed the previous ROW instead of COLUMN value.

However, you can add a group name to the function (it is not documented in Visual Studio, but it works) where you add the Column group name like so:
=Previous(Sum(Fields!RegBedrHJ.Value),”Per3″)
This way you get the previous value from a column and can compare the two.

Create a 360 sphere for Google Streetview with a DJI panorama

Making 360 panorama’s for Google Streetview.   I use Autopano Giga for stitching the pictures. But most of the software will work just fine. Click ‘Detect’ and Autopano will make a panoramic picture. Click ‘Edit’ to make some adjustments to the panorama. Make sure the projection settings is set to ‘Sperical’ Crop the picture to […]

Report definition not valid error 2015

After updating our ssrs 2012 environment to visual studio 2015 I sometimes get an error when deploying a report. Error rsProcessingError : The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content […]