Pivot Table Values as a % of a Subtotal

  • Follow


Hi!  I have a pivot table that is summarizing sales data by "facility type" 
and then "product category".  I want to present the data with each value 
shown as a % of the relevant subtotal (depending on which facility type and 
product category it happens to be in)...not of the column as a whole.  Is 
this possible?  If so, how?

Much appreciated!
2
Reply Utf 1/26/2010 9:11:02 PM

Excel 2010 has this feature -- % of parent. You'll have to wait! :-(

"Little Mojo" <david.j.snyder@united.com> wrote in message 
news:06B1C68C-868C-4E6C-A6A8-B705358E4CB8@microsoft.com...
> Hi!  I have a pivot table that is summarizing sales data by "facility 
> type"
> and then "product category".  I want to present the data with each value
> shown as a % of the relevant subtotal (depending on which facility type 
> and
> product category it happens to be in)...not of the column as a whole.  Is
> this possible?  If so, how?
>
> Much appreciated! 

1
Reply Bob 1/26/2010 9:18:29 PM


1 Replies
589 Views

(page loaded in 0.052 seconds)

Similiar Articles:
















7/22/2012 2:38:21 AM


Reply: