A column with fomula for product sharing of total in pivot

[TehseenAfzal]

Hi All,

I want to insert a column in last of pivot table like

grand total sharing
10 20%
10 20%
10 20%
20 40%
--------
50
--------

The colum i required is highlited with red color.
Your early reply is my pleasure

 

[TehseenAfzal]

I have a sheet contain data and in a other sheet i maintain a pivot table report like below.

IMPORTER ABC COMPANY
GENERIC NAME (All)
YEAR 2006
DATA SOURCE (All)

VALUE ($) MONTH
BRAND NAME PACK SIZE Jul-06 Aug-06 Grand Total
PRODUCT 1 1Vial (3 MIU) 272,834 60,000 332,834
1Vial (5 MIU) 7,480 7,480

Grand Total 272,834 67,480 340,314

in this table report showing abc company import a product in two diffrent packing in 2006.
and my requirement is that sharing of total value of both product in %
thank you