| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
% of calculated field in pivot table
I was hoping to get some help with a calculated field in a pivot table.
I'm trying to create a "% of sales" formula (value of each color/total). I'm navigating to (pivot table\formula\calculated field) to build the formula, I'm lacking the knowledge to use the field items to build the formula. Any help would be greatly appreciated. Color Unit Sales Black 10 Brown 10 Red 10 Total 30 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| Calculated Field in Pivot Table | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
