How do I get the percentage of total for a large data set

[mdeanda]

When subtotaling a column based on a field change in another column can Excel
also calculate percentages for each value that makes up the sub total.

What I realy need are the percentages

EXAMPLE
NAME1 100
NAME1 100
NAME1 100
NAME1 100
NAME2 300
NAME2 300

DESIRED RESULT
NAME1 100 .25
NAME1 100 .25
NAME1 100 .25
NAME1 100 .25
$400
NAME2 300 .5
NAME2 300 .5
$600

[Jim Thomlinson]

Instead of subtotaling use a pivot table. That functionallity is built right
into a pivot table. Data that is easily subtotaled is ideal for pivot tables.
Look them up in the help files to get started and get back to us if you have
any difficulty.
--
HTH...

Jim Thomlinson


"mdeanda" wrote:

> When subtotaling a column based on a field change in another column can Excel
> also calculate percentages for each value that makes up the sub total.
>
> What I realy need are the percentages
>
> EXAMPLE
> NAME1 100
> NAME1 100
> NAME1 100
> NAME1 100
> NAME2 300
> NAME2 300
>
> DESIRED RESULT
> NAME1 100 .25
> NAME1 100 .25
> NAME1 100 .25
> NAME1 100 .25
> $400
> NAME2 300 .5
> NAME2 300 .5
> $600

[mdeanda]

Pivot Table: In the drop down box for "subtotals" I saw nothing that would
return a percentage. How would I complet this task.

Each row has other data that I need to send to another application so I need
the percentage figure on the the same line not below or above.

Thank You

"mdeanda" wrote:

> When subtotaling a column based on a field change in another column can Excel
> also calculate percentages for each value that makes up the sub total.
>
> What I realy need are the percentages
>
> EXAMPLE
> NAME1 100
> NAME1 100
> NAME1 100
> NAME1 100
> NAME2 300
> NAME2 300
>
> DESIRED RESULT
> NAME1 100 .25
> NAME1 100 .25
> NAME1 100 .25
> NAME1 100 .25
> $400
> NAME2 300 .5
> NAME2 300 .5
> $600

[mdeanda]

Pivot Table: In the drop down box for "subtotals" I saw nothing that would
return a percentage. How would I complet this task.

Each row has other data that I need to send to another application so I need
the percentage figure on the the same line not below or above.

Thank You



"Jim Thomlinson" wrote:

> Instead of subtotaling use a pivot table. That functionallity is built right
> into a pivot table. Data that is easily subtotaled is ideal for pivot tables.
> Look them up in the help files to get started and get back to us if you have
> any difficulty.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "mdeanda" wrote:
>
> > When subtotaling a column based on a field change in another column can Excel
> > also calculate percentages for each value that makes up the sub total.
> >
> > What I realy need are the percentages
> >
> > EXAMPLE
> > NAME1 100
> > NAME1 100
> > NAME1 100
> > NAME1 100
> > NAME2 300
> > NAME2 300
> >
> > DESIRED RESULT
> > NAME1 100 .25
> > NAME1 100 .25
> > NAME1 100 .25
> > NAME1 100 .25
> > $400
> > NAME2 300 .5
> > NAME2 300 .5
> > $600

[David]

Hi,
I am not sure if this may not be more than you want, but I have a fair
amount of analyis before, so I thought I would share it with you.
First just run regular subtotals with the change being the Name, this will
give you two subtotals and a Grand Total.

Next is a formula,
Layout:
Name Amt
NAME1 100 25% 10% =FIXED(+B2/$B$6*100,0)&"%
"&FIXED(+B2/$B$10*100,0)&"%"
NAME1 100 25% 10%
NAME1 100 25% 10%
NAME1 100 25% 10%
NAME1 Total 400 100% 40%
NAME2 300 50% 30%
NAME2 300 50% 30%
NAME2 Total 600 100% 60% =FIXED(+B9/$B$9*100,0)&"%
"&FIXED(+B9/$B$10*100,0)&"%"
Grand Total 1000 100% 100%
This gives you percent of each individual total and % of Grand Total.

Thanks,


"mdeanda" wrote:

> Pivot Table: In the drop down box for "subtotals" I saw nothing that would
> return a percentage. How would I complet this task.
>
> Each row has other data that I need to send to another application so I need
> the percentage figure on the the same line not below or above.
>
> Thank You
>
> "mdeanda" wrote:
>
> > When subtotaling a column based on a field change in another column can Excel
> > also calculate percentages for each value that makes up the sub total.
> >
> > What I realy need are the percentages
> >
> > EXAMPLE
> > NAME1 100
> > NAME1 100
> > NAME1 100
> > NAME1 100
> > NAME2 300
> > NAME2 300
> >
> > DESIRED RESULT
> > NAME1 100 .25
> > NAME1 100 .25
> > NAME1 100 .25
> > NAME1 100 .25
> > $400
> > NAME2 300 .5
> > NAME2 300 .5
> > $600

[Jim Thomlinson]

Sorry about taking so long to get back to you. Add the same field in twice.
Now on the second instance of the field under field settings select options
and now you can choose how you want to aggregate your data. In this case as %
of...
--
HTH...

Jim Thomlinson


"mdeanda" wrote:

> Pivot Table: In the drop down box for "subtotals" I saw nothing that would
> return a percentage. How would I complet this task.
>
> Each row has other data that I need to send to another application so I need
> the percentage figure on the the same line not below or above.
>
> Thank You
>
>
>
> "Jim Thomlinson" wrote:
>
> > Instead of subtotaling use a pivot table. That functionallity is built right
> > into a pivot table. Data that is easily subtotaled is ideal for pivot tables.
> > Look them up in the help files to get started and get back to us if you have
> > any difficulty.
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "mdeanda" wrote:
> >
> > > When subtotaling a column based on a field change in another column can Excel
> > > also calculate percentages for each value that makes up the sub total.
> > >
> > > What I realy need are the percentages
> > >
> > > EXAMPLE
> > > NAME1 100
> > > NAME1 100
> > > NAME1 100
> > > NAME1 100
> > > NAME2 300
> > > NAME2 300
> > >
> > > DESIRED RESULT
> > > NAME1 100 .25
> > > NAME1 100 .25
> > > NAME1 100 .25
> > > NAME1 100 .25
> > > $400
> > > NAME2 300 .5
> > > NAME2 300 .5
> > > $600