Pivot table - show values as

Hi,

I have a pivot table with three columns:
1) Month
2) Total Sales
3) Shoes Sales

I want to show the values of the Shoes Sales column as a percentage of the Total Sales column. Can you please guide me on how I do that?

thanks!

Have a read here:

http://www.contextures.com/xlPivot10.html

and

http://support.microsoft.com/kb/106359

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I think you will need to do the calculation in another column of the data table

V - You created this post on 04 Nov and a member took the time to help you. Please mark it as solved........

http://www.excelforum.com/excel-gene...ting-data.html

Is this what your were after, see attached? ,,,,,,,,Go to Pivot table tools (top right) > options > Formulas > Calculated Field > Formula = then do the biz!

Quote:
Originally Posted by FAQ
To mark your thread solved do the following: - Go to the first post - Click edit - Click Advance - Just below the word "Title:" you will see a dropdown with the word No prefix. - Change to Solve - Click Save

please don't forget to mark this as solved...

nice one. Cheers dude