[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1172
  • Last Modified:

Adding an Average column in Reporting services

How would I add an AVG. column for reporting services report? My source is a view in sql.
Currently I have a matrix for class and weeks.  Thanks
                          Wk1      Wk2      Wk 3    wk4     Total  AVG?
   ClassA          40            50       60       30           180  ?
  ClassB           60          40        50        10            160 ?
Class C           100         80        90        70            340 ?
Total              200         170        200      110           680
0
zachvaldez
Asked:
zachvaldez
  • 5
  • 4
2 Solutions
 
planoczCommented:
use your expressions in a textbox field. If you look at the expression Edit box under Aggregate there is a Avg function that you can use.
0
 
zachvaldezAuthor Commented:
u mean I hae to drag and drop a textbox instead of adding a column?
0
 
planoczCommented:
If you are using a table you can add a column by right clicking on the body header bar.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
zachvaldezAuthor Commented:
Im using matrix. Can you please provide more details on your suggestions.
0
 
planoczCommented:
If you already have a group in your matrix just add a textbox and use the Avg expression.
0
 
zachvaldezAuthor Commented:
Hi,
 I can't picture what you're suggesting. Would you please add details to my question?
0
 
planoczCommented:
I am in meetings  all day I will have to get back with you.
0
 
zachvaldezAuthor Commented:
thanks
0
 
planoczCommented:
You have to go to the leftside of the table and right click then add a row group and place your fields in there. then add your new avg cell to the end of you row and sum the field.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now