A problem with a chart

Dear all,

I'm kinda new to reporting services and I have a small problem. Currently I'm using RS 2000, and I have a bar chart on my report. It displays names on the x-axis (I group by the name) and total number of hours on the y-axis (the value). I need to change that total number of hours with a percentage from the whole number of hours worked. My problem is I'm not capable of getting the total number of hours worked per all users since I'm grouping by users. How could I do that?

Any help regarding that issue is appreciated.You can calculate the total number of hours by using an aggregate function with an explicit scope name of the name of the chart reportitem. E.g.:
=Sum(Fields!Hours.Value, "chart1")

The percentage can be calculated as =Sum(Fields!Hours.Value) / Sum(Fields!Hours.Value, "chart1")

-- Robert