Prev: When refreshed, some Pivot Table columns retain formatting, some d
Next: why this strange result with vlookup
From: JoeM on 22 Apr 2010 14:16
I have a pivot table I want to do percentage of total on:

Column 1 Column2
Ice Cream 32
Cake 50
Total 82

I want to add a third column that says 32 is 39% of the total 82. And 50 is
61% of the total. The system should be able to calculate this.
I tried to do a search but couldn't get anything to come back.

From: trip_to_tokyo on 22 Apr 2010 14:50
EXCEL 2007

In your, "value column" you can right click in the Column Name / Value Field
Settings / Show values as tab / change the Show values as field to % of
column / OK

Not quite what you want.

If my comments have helped please hit Yes.

"JoeM" wrote:

> I have a pivot table I want to do percentage of total on:
>
> Column 1 Column2
> Ice Cream 32
> Cake 50
> Total 82
>
> I want to add a third column that says 32 is 39% of the total 82. And 50 is
> 61% of the total. The system should be able to calculate this.
> I tried to do a search but couldn't get anything to come back.
>
From: JoeM on 22 Apr 2010 17:14
My problem is getting it to create that third column that says this is 39% of
the total.
Joe

"trip_to_tokyo" wrote:

> EXCEL 2007
>
> In your, "value column" you can right click in the Column Name / Value Field
> Settings / Show values as tab / change the Show values as field to % of
> column / OK
>
> Not quite what you want.
>
> If my comments have helped please hit Yes.
>
> "JoeM" wrote:
>
> > I have a pivot table I want to do percentage of total on:
> >
> > Column 1 Column2
> > Ice Cream 32
> > Cake 50
> > Total 82
> >
> > I want to add a third column that says 32 is 39% of the total 82. And 50 is
> > 61% of the total. The system should be able to calculate this.
> > I tried to do a search but couldn't get anything to come back.
> >
From: Ashish Mathur on 25 Apr 2010 06:10
Hi,

Drag column 2 to the pivot once again (it should appear two times in the
data area of the pivot). Right click on any one and then go to Value
fields settings > Show as > % of column

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JoeM" <JoeM(a)discussions.microsoft.com> wrote in message
news:E7564555-2488-4F09-A518-F968C266FDE1(a)microsoft.com...
> I have a pivot table I want to do percentage of total on:
>
> Column 1 Column2
> Ice Cream 32
> Cake 50
> Total 82
>
> I want to add a third column that says 32 is 39% of the total 82. And 50
> is
> 61% of the total. The system should be able to calculate this.
> I tried to do a search but couldn't get anything to come back.
>
 | 
Pages: 1
Prev: When refreshed, some Pivot Table columns retain formatting, some d
Next: why this strange result with vlookup