May 8, 2008 at 6:26 am
I have data in a matrix that shows a percent, and that is fine, but when it shows the subtotal it just sums all the percents instead of getting an average of all the data in that row. I'm looking for help here for what seems would be easy but it's been hours and I haven't figured out yet how to do this. All the rest of the data is fine because it does what it should (sum) but it's this one row that is giving me a headache.
Thanks for the help.
May 8, 2008 at 7:26 am
You need to change the function in the data row of the matrix to AVG() from SUM() if you want the subtotals/totals to be Avg()
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 8, 2008 at 7:48 pm
It worked! Thanks Alot!
Now I wonder if there is a way that reporting services can sum or average time.
July 5, 2008 at 5:17 am
me also facing same issue, Can you send the Solution
Thanks in Advance,
D.Ravi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply