Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate percentage in pivot
Hello,
Please would someone let me know if it is possible to add a field into a pivot table which calculates each field's value as a percentage of the total? For example, I have a pivot table which shows the following SALES UK 20,000 France 10,000 Spain 10,000 GRAND TOTAL 40,000 I want to add a column which shows that the UK has 50% of the Grand Total and France and Spain have 25% each respectively. Thanks very much, Dan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate percentage in pivot
Right click on the values and select field settings. Click options and in the
"Show Data As" drop down select "% of Total"... -- HTH... Jim Thomlinson "Dan" wrote: Hello, Please would someone let me know if it is possible to add a field into a pivot table which calculates each field's value as a percentage of the total? For example, I have a pivot table which shows the following SALES UK 20,000 France 10,000 Spain 10,000 GRAND TOTAL 40,000 I want to add a column which shows that the UK has 50% of the Grand Total and France and Spain have 25% each respectively. Thanks very much, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to us Pivot Table to calculate the % of one Item ("Yes") | Excel Worksheet Functions | |||
Pivot table from CSV data, problem with percentage of total. | Excel Worksheet Functions | |||
How to calculate percentage acroos sheets in a workbook | Excel Discussion (Misc queries) | |||
Calculate Difference between 2 columns in Pivot table | Excel Discussion (Misc queries) | |||
Calculate number based on percentage | Excel Worksheet Functions |