INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Matrix-calculate the variance of the rows

Matrix-calculate the variance of the rows

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close