Dear all
I am facing the following issue and I am kindly requesting your help.
I designed a report using a matrix.
The rows region displays the years 2014 and 2015 (dynamically selected by the user).
The columns region displays the months (dynamically selected by the user).
The data region displays the values.
I added a bottom row to display the variance of each month between the years selected by the user.
In other words:
the first column holds the month January,
the last column holds the sum of the selected period using the Aggregate function instead of the sum (due to the particularity of the measure - it counts the unique invoiced customers)
the first row holds the year 2014,
the second row holds the year 2015,
the third row should hold the variance of January between 2014 and 2015
I am trying to find the method to calculate this variance in the last column (i.e. the period column).
Any ideas how to resolve it?
br
I am facing the following issue and I am kindly requesting your help.
I designed a report using a matrix.
The rows region displays the years 2014 and 2015 (dynamically selected by the user).
The columns region displays the months (dynamically selected by the user).
The data region displays the values.
I added a bottom row to display the variance of each month between the years selected by the user.
In other words:
the first column holds the month January,
the last column holds the sum of the selected period using the Aggregate function instead of the sum (due to the particularity of the measure - it counts the unique invoiced customers)
the first row holds the year 2014,
the second row holds the year 2015,
the third row should hold the variance of January between 2014 and 2015
I am trying to find the method to calculate this variance in the last column (i.e. the period column).
Any ideas how to resolve it?
br