Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Matrix-calculate the variance of the rows

Status
Not open for further replies.

antservos

Programmer
Jul 8, 2015
2
GR
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top