Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to us Pivot Table to calculate the % of one Item ("Yes")
I am trying to calculate the % of time a word("Yes") appears in a column
realtive to other variables in another column. Example if I have 3 mills x, y and z and i want to know the % of times that the word "yes" appears in all entries for mill x, how do I that? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to us Pivot Table to calculate the % of one Item ("Yes")
Highlight your column of data, then Data Pivot Table... Click Next, Next,
then Layout. Drag 'mill' to the row header field, and drag it also to the data field. Click OK then Finish. Right-click in one of the mill's 'total' fields (where you see the number indicating how many times it appeared). Select Field Settings, then Options. Use the lower drop-down, 'Show data as' and select "% of column." Click OK. "El tenacious D" wrote: I am trying to calculate the % of time a word("Yes") appears in a column realtive to other variables in another column. Example if I have 3 mills x, y and z and i want to know the % of times that the word "yes" appears in all entries for mill x, how do I that? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate PivotTable Item Totals Based On Cell Contents? | Excel Worksheet Functions | |||
PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
Pivot table column duplicates | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |