I have a matrix report that has an embedded Pie chart on the Rows box for the
Matirx. This produces a Pie for each row that shows up on the report.
Everything shows up fine but I want to show a percent on the Pie rather than
showing the hours calculation. I have figured out how to do this for a
single pie,with some of the message boards help. e.g.
=(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
However, when I try this on a matrix the percentages are very small because
it is looking at the sum of the total not the sum of the scope or rows that
should be included. Any ideas on what the formula should look like base ont
he information provided?
I have tried =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value,
"Vice_President")
but I get the following error: The expression for the chart â'chart2â' 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 -- 1 errors, 0 warnings
This is what I have defined for the matrix:
Rows: Pie Chart (New Pie for each row)
Data: Reg_Hours (Sum of hours for each pie spread across the Proj_Cat columns)
Columns: Project_Category (Dynamic list of columns that contain the hours
for each
category)
In the pie chart I have the following:
Series Fields: Proj_Cat
Data Fields: Reg_Hours
Category Field: NothingAssuming the reportitem name of your pie chart is "Chart1", please try the
following expression for the datapoint labels:
=Fields!Reg_Hours.Value / Sum(Fields!Reg_Hours.Value, "Chart1")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:9CD07032-6031-4C5F-BBBA-FE58C67CB8F5@.microsoft.com...
>I have a matrix report that has an embedded Pie chart on the Rows box for
>the
> Matirx. This produces a Pie for each row that shows up on the report.
> Everything shows up fine but I want to show a percent on the Pie rather
> than
> showing the hours calculation. I have figured out how to do this for a
> single pie,with some of the message boards help. e.g.
> =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
> However, when I try this on a matrix the percentages are very small
> because
> it is looking at the sum of the total not the sum of the scope or rows
> that
> should be included. Any ideas on what the formula should look like base
> ont
> he information provided?
> I have tried =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value,
> "Vice_President")
> but I get the following error: The expression for the chart 'chart2' 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 -- 1 errors, 0 warnings
> This is what I have defined for the matrix:
> Rows: Pie Chart (New Pie for each row)
> Data: Reg_Hours (Sum of hours for each pie spread across the Proj_Cat
> columns)
> Columns: Project_Category (Dynamic list of columns that contain the hours
> for each
> category)
> In the pie chart I have the following:
> Series Fields: Proj_Cat
> Data Fields: Reg_Hours
> Category Field: Nothing
>|||You had the formula right...I jsut missed the caps on chart1 which is case
sensitive
This worked:
=Fields!Reg_Hours.Value / Sum(Fields!Reg_Hours.Value, "chart1")
Thanks for all the help!!!
"Robert Bruckner [MSFT]" wrote:
> Assuming the reportitem name of your pie chart is "Chart1", please try the
> following expression for the datapoint labels:
> =Fields!Reg_Hours.Value / Sum(Fields!Reg_Hours.Value, "Chart1")
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:9CD07032-6031-4C5F-BBBA-FE58C67CB8F5@.microsoft.com...
> >I have a matrix report that has an embedded Pie chart on the Rows box for
> >the
> > Matirx. This produces a Pie for each row that shows up on the report.
> > Everything shows up fine but I want to show a percent on the Pie rather
> > than
> > showing the hours calculation. I have figured out how to do this for a
> > single pie,with some of the message boards help. e.g.
> > =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
> >
> > However, when I try this on a matrix the percentages are very small
> > because
> > it is looking at the sum of the total not the sum of the scope or rows
> > that
> > should be included. Any ideas on what the formula should look like base
> > ont
> > he information provided?
> >
> > I have tried =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value,
> > "Vice_President")
> >
> > but I get the following error: The expression for the chart 'chart2' 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 -- 1 errors, 0 warnings
> >
> > This is what I have defined for the matrix:
> > Rows: Pie Chart (New Pie for each row)
> > Data: Reg_Hours (Sum of hours for each pie spread across the Proj_Cat
> > columns)
> > Columns: Project_Category (Dynamic list of columns that contain the hours
> > for each
> > category)
> >
> > In the pie chart I have the following:
> > Series Fields: Proj_Cat
> > Data Fields: Reg_Hours
> > Category Field: Nothing
> >
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment