% on Pie Charts

Hello all,
I am currently showing the value (hours) for each slice of the pie chart but
would like to also include the percentage of that pie slice. How would I do
this?Hi Anthonysjo,
SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
then Format Code: P.
Or
Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
"Percent")
I hope this is what you are looking for.
Kerrie
anthonysjo wrote:
>Hello all,
>I am currently showing the value (hours) for each slice of the pie chart but
>would like to also include the percentage of that pie slice. How would I do
>this?
Message posted via http://www.sqlmonster.com|||Kerrie,
thanks for the help, but I may need a little more explaination....would I
put this formula in the Chart properties, on the data tab, values, edit, and
add the code to the Value field? Also is Dataset1 the name of the datasource
or the name of the output field in the example you gave below?
Thanks for the help!!
Anthony
"Kerrie S via SQLMonster.com" wrote:
> Hi Anthonysjo,
> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
> then Format Code: P.
> Or
> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
> "Percent")
> I hope this is what you are looking for.
> Kerrie
> anthonysjo wrote:
> >Hello all,
> >
> >I am currently showing the value (hours) for each slice of the pie chart but
> >would like to also include the percentage of that pie slice. How would I do
> >this?
>
> --
> Message posted via http://www.sqlmonster.com
>|||That expression would go under data tab -> edit values -> point labels
tab -> data label expression
"Dataset1" is an explicit scope for the Sum aggregation function and has to
be identical to the data set name the chart is based on.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
> Kerrie,
> thanks for the help, but I may need a little more explaination....would I
> put this formula in the Chart properties, on the data tab, values, edit,
> and
> add the code to the Value field? Also is Dataset1 the name of the
> datasource
> or the name of the output field in the example you gave below?
> Thanks for the help!!
> Anthony
> "Kerrie S via SQLMonster.com" wrote:
>> Hi Anthonysjo,
>> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
>> then Format Code: P.
>> Or
>> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
>> "Percent")
>> I hope this is what you are looking for.
>> Kerrie
>> anthonysjo wrote:
>> >Hello all,
>> >
>> >I am currently showing the value (hours) for each slice of the pie chart
>> >but
>> >would like to also include the percentage of that pie slice. How would
>> >I do
>> >this?
>>
>> --
>> Message posted via http://www.sqlmonster.com|||I put in the following.....
=SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, " YRT_Proj_Cat")
Then I ran the report and get the following error:
The expression for the chart â'chart1â' has a scope parameter that is not
valid for an aggregate function. The scope parameter must be set to a string
constant that is equal to either the name of a containing group, the name of
a containing data region, or the name of a data set.
Build complete
What am I missing...Reg_Hours is the field name and YRT_Proj_Cat is the
dataset?
Sorry if I am a little slow...I am new to SRS!
Thanks for the help thus far!!!
"Robert Bruckner [MSFT]" wrote:
> That expression would go under data tab -> edit values -> point labels
> tab -> data label expression
> "Dataset1" is an explicit scope for the Sum aggregation function and has to
> be identical to the data set name the chart is based on.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
> > Kerrie,
> >
> > thanks for the help, but I may need a little more explaination....would I
> > put this formula in the Chart properties, on the data tab, values, edit,
> > and
> > add the code to the Value field? Also is Dataset1 the name of the
> > datasource
> > or the name of the output field in the example you gave below?
> >
> > Thanks for the help!!
> >
> > Anthony
> > "Kerrie S via SQLMonster.com" wrote:
> >
> >> Hi Anthonysjo,
> >> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
> >> then Format Code: P.
> >> Or
> >> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
> >> "Percent")
> >> I hope this is what you are looking for.
> >> Kerrie
> >>
> >> anthonysjo wrote:
> >> >Hello all,
> >> >
> >> >I am currently showing the value (hours) for each slice of the pie chart
> >> >but
> >> >would like to also include the percentage of that pie slice. How would
> >> >I do
> >> >this?
> >>
> >>
> >> --
> >> Message posted via http://www.sqlmonster.com
> >>
>
>|||Scope names are case-sensitive and they must exactly match the data set
name. The scope name in the expressions starts with a space which is most
likely the reason for the error message. Try it without the leading space in
the scope name:
=SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:AE6D597D-D4CF-4EEB-9EFB-A223A8734D27@.microsoft.com...
>I put in the following.....
> =SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "
> YRT_Proj_Cat")
> Then I ran the report and get the following error:
> The expression for the chart 'chart1' has a scope parameter that is not
> valid for an aggregate function. The scope parameter must be set to a
> string
> constant that is equal to either the name of a containing group, the name
> of
> a containing data region, or the name of a data set.
> Build complete
> What am I missing...Reg_Hours is the field name and YRT_Proj_Cat is the
> dataset?
> Sorry if I am a little slow...I am new to SRS!
> Thanks for the help thus far!!!
> "Robert Bruckner [MSFT]" wrote:
>> That expression would go under data tab -> edit values -> point labels
>> tab -> data label expression
>> "Dataset1" is an explicit scope for the Sum aggregation function and has
>> to
>> be identical to the data set name the chart is based on.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
>> news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
>> > Kerrie,
>> >
>> > thanks for the help, but I may need a little more
>> > explaination....would I
>> > put this formula in the Chart properties, on the data tab, values,
>> > edit,
>> > and
>> > add the code to the Value field? Also is Dataset1 the name of the
>> > datasource
>> > or the name of the output field in the example you gave below?
>> >
>> > Thanks for the help!!
>> >
>> > Anthony
>> > "Kerrie S via SQLMonster.com" wrote:
>> >
>> >> Hi Anthonysjo,
>> >> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
>> >> then Format Code: P.
>> >> Or
>> >> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
>> >> "Percent")
>> >> I hope this is what you are looking for.
>> >> Kerrie
>> >>
>> >> anthonysjo wrote:
>> >> >Hello all,
>> >> >
>> >> >I am currently showing the value (hours) for each slice of the pie
>> >> >chart
>> >> >but
>> >> >would like to also include the percentage of that pie slice. How
>> >> >would
>> >> >I do
>> >> >this?
>> >>
>> >>
>> >> --
>> >> Message posted via http://www.sqlmonster.com
>> >>
>>|||Sweet!! That was it...the space was causing the problem. Thanks for the
help!!!
"Robert Bruckner [MSFT]" wrote:
> Scope names are case-sensitive and they must exactly match the data set
> name. The scope name in the expressions starts with a space which is most
> likely the reason for the error message. Try it without the leading space in
> the scope name:
> =SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:AE6D597D-D4CF-4EEB-9EFB-A223A8734D27@.microsoft.com...
> >I put in the following.....
> >
> > =SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "
> > YRT_Proj_Cat")
> >
> > Then I ran the report and get the following error:
> >
> > The expression for the chart 'chart1' has a scope parameter that is not
> > valid for an aggregate function. The scope parameter must be set to a
> > string
> > constant that is equal to either the name of a containing group, the name
> > of
> > a containing data region, or the name of a data set.
> > Build complete
> >
> > What am I missing...Reg_Hours is the field name and YRT_Proj_Cat is the
> > dataset?
> >
> > Sorry if I am a little slow...I am new to SRS!
> >
> > Thanks for the help thus far!!!
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> That expression would go under data tab -> edit values -> point labels
> >> tab -> data label expression
> >>
> >> "Dataset1" is an explicit scope for the Sum aggregation function and has
> >> to
> >> be identical to the data set name the chart is based on.
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> >> news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
> >> > Kerrie,
> >> >
> >> > thanks for the help, but I may need a little more
> >> > explaination....would I
> >> > put this formula in the Chart properties, on the data tab, values,
> >> > edit,
> >> > and
> >> > add the code to the Value field? Also is Dataset1 the name of the
> >> > datasource
> >> > or the name of the output field in the example you gave below?
> >> >
> >> > Thanks for the help!!
> >> >
> >> > Anthony
> >> > "Kerrie S via SQLMonster.com" wrote:
> >> >
> >> >> Hi Anthonysjo,
> >> >> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
> >> >> then Format Code: P.
> >> >> Or
> >> >> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
> >> >> "Percent")
> >> >> I hope this is what you are looking for.
> >> >> Kerrie
> >> >>
> >> >> anthonysjo wrote:
> >> >> >Hello all,
> >> >> >
> >> >> >I am currently showing the value (hours) for each slice of the pie
> >> >> >chart
> >> >> >but
> >> >> >would like to also include the percentage of that pie slice. How
> >> >> >would
> >> >> >I do
> >> >> >this?
> >> >>
> >> >>
> >> >> --
> >> >> Message posted via http://www.sqlmonster.com
> >> >>
> >>
> >>
> >>
>
>