Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Row Label Combination
In my source data have have two separate columns which contain the same type of data.
Column #1 is "Symptom 1" and contains data such as "Broken/Damaged", "Cosmetic", "Labeling - Incorrect". Column #2 is "Symptom 2" and contains data such as "Broken/Damaged", "Cosmetic", "Labeling - Incorrect". When I drag these two columns into the Row Labels on my pivot table the Column #2 is a subset of Column 1. Since they contain the same information, but for different non-conformances, I'd like to combine Column 1 and Column 2 into the same row label without subsets such that I can have a total amount of Symptom, whether it be Symptom 1 or Symptom 2. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat Label on Pivot Table | Excel Programming | |||
Formula in combination with pivot table | Excel Worksheet Functions | |||
How can I list every data combination from a large pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table Label | Excel Worksheet Functions | |||
Pivot Table Label | Excel Discussion (Misc queries) |