Calculating percent of total

I have a table which has two groupings in it. I am subtotalling a field in
each groups footer and would like to show the % to total on the first footer.
Essentially, I need total qty for group 1 divided by total qty for group 2.
How do I create an expression to do this?
thanks!
MarthaUse the RunningValue Function, such as
RunningValue(Fields!Amount,Sum,Nothing).
"Martha" wrote:
> I have a table which has two groupings in it. I am subtotalling a field in
> each groups footer and would like to show the % to total on the first footer.
> Essentially, I need total qty for group 1 divided by total qty for group 2.
> How do I create an expression to do this?
> thanks!
> Martha|||Dave - thanks but I am a little unsure how this would help?
Here's the situation - I have a group for department and another group for
project. I am totalling hours at the project and the department group footers
and I would like to divide the department subtotal by the project subtotal to
get a % for each project to the total department. Currently, my subtotal
fields are technically the same field so I get 100% on every project. How do
I identify these subtotals as being from different groups?
thanks for helping,
Martha
"Dave" wrote:
> Use the RunningValue Function, such as
> RunningValue(Fields!Amount,Sum,Nothing).
> "Martha" wrote:
> > I have a table which has two groupings in it. I am subtotalling a field in
> > each groups footer and would like to show the % to total on the first footer.
> > Essentially, I need total qty for group 1 divided by total qty for group 2.
> > How do I create an expression to do this?
> >
> > thanks!
> >
> > Martha|||Under the group section footer, you can use =SUM(Amount) /
RunningValue(Amount,Sum,Nothing). The third parameter of the function
defines the scope of the Sum. In this case, Nothing says sum all values in
the dataset.
"Martha" wrote:
> Dave - thanks but I am a little unsure how this would help?
> Here's the situation - I have a group for department and another group for
> project. I am totalling hours at the project and the department group footers
> and I would like to divide the department subtotal by the project subtotal to
> get a % for each project to the total department. Currently, my subtotal
> fields are technically the same field so I get 100% on every project. How do
> I identify these subtotals as being from different groups?
> thanks for helping,
> Martha
>
> "Dave" wrote:
> > Use the RunningValue Function, such as
> > RunningValue(Fields!Amount,Sum,Nothing).
> >
> > "Martha" wrote:
> >
> > > I have a table which has two groupings in it. I am subtotalling a field in
> > > each groups footer and would like to show the % to total on the first footer.
> > > Essentially, I need total qty for group 1 divided by total qty for group 2.
> > > How do I create an expression to do this?
> > >
> > > thanks!
> > >
> > > Martha