How to derive %Contribution to each Subtotal In Pivot table?

S

saurabhbiswas123

Joined
Feb 6, 2009
Messages
1
Reaction score
0
Dear All,

I do have a Pivot Table(in excel 2003 format) from A4:C17 as per the details given below.

CategoryClassTotalMensMN CASUAL JEANS6185 MN CASUAL SHIRTS7521 MN CASUAL TROUSERS30404 MN CASUAL T-SHIRTS34398 MN FORMAL SHIRT146609 MN FORMAL TROUSERS33637Mens Total 258754LadiesWN CASUAL JEANS3146 WN CASUAL KURTIS97845 WN CASUAL SHIRTS8979 WN CASUAL T-SHIRTS20921Ladies Total 130891Grand Total 389645

I would like to convert the absolute data to Percentage as per the below mentioned matrix(in the Pivot Table itself):-
Proposed Format(In Pivot Table Itself)CategoryClassTotalMensMN CASUAL JEANS2%MN CASUAL SHIRTS3%MN CASUAL TROUSERS12%MN CASUAL T-SHIRTS13%MN FORMAL SHIRT57%MN FORMAL TROUSERS13%Mens Total 100%LadiesWN CASUAL JEANS2%WN CASUAL KURTIS75%WN CASUAL SHIRTS7%WN CASUAL T-SHIRTS16%Ladies Total 100%Grand Total
I have used the options in the pivot table(Field Setting-Options-Show Data as-%Of Total) but the following result is coming:-
Proposed Format(In Pivot Table Itself)CategoryClassTotalMensMN CASUAL JEANS2%MN CASUAL SHIRTS2%MN CASUAL TROUSERS8%MN CASUAL T-SHIRTS9%MN FORMAL SHIRT38%MN FORMAL TROUSERS9%Mens Total 66%LadiesWN CASUAL JEANS1%WN CASUAL KURTIS25%WN CASUAL SHIRTS2%WN CASUAL T-SHIRTS5%Ladies Total 34%Grand Total 100%

Pls help in sorting this out.
Thanks
Saurabh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table - 3
Column Heading on each row in pivot table 1
% of subtotal in pivot table 1
How to group Columns in Pivot Table? 5
Pivot Table: showing data as % of subtotal 1
Pivot Table Subtotals 1
Pivot table - subtotal at top of column 1

Top