Pivot tables % of subtotal

Is there a way to display data like I've shown it below. In case it is
unclear, I'd like to calculate a percentage of sales of size 1 to the total
sales of the various sizes of a product. For example, Prod A, size 1, as a
percentage of total sales of Prod A, sizes 1-3.


Product Size Units %
A 1 100 16.7%
A 2 200 33.3%
A 3 300 50.0%
A Total 600 100.0%

B 1 150 20.0%
B 2 350 46.7%
B 3 250 33.3%
B Total 750 100.0%

Total 1350 100.0%

It looks like you want to review Debra Dalgleish's notes at:
http://www.contextures.com/xlPivot10.html



Excel GuRu wrote:
>
> Is there a way to display data like I've shown it below. In case it is
> unclear, I'd like to calculate a percentage of sales of size 1 to the total
> sales of the various sizes of a product. For example, Prod A, size 1, as a
> percentage of total sales of Prod A, sizes 1-3.
>
>
> Product Size Units %
> A 1 100 16.7%
> A 2 200 33.3%
> A 3 300 50.0%
> A Total 600 100.0%
>
> B 1 150 20.0%
> B 2 350 46.7%
> B 3 250 33.3%
> B Total 750 100.0%
>
> Total 1350 100.0%
>

--

Dave Peterson