Pivot Table Values as a % of a Subtotal
in [General]
|
Prev: Make a Template Available to Multiple Users
Next: Can you lock a drop-down cell so that it sorts with the row?
From: Little Mojo on 26 Jan 2010 16:11 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!
From: Bob Umlas on 26 Jan 2010 16:18
Excel 2010 has this feature -- % of parent. You'll have to wait! :-( "Little Mojo" <david.j.snyder(a)united.com> wrote in message news:06B1C68C-868C-4E6C-A6A8-B705358E4CB8(a)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! |