Except the defaults to the questions, “Where is the data you want to analyze?” Should be, “Microsoft Office Excel list or database” AND “What kind of report do you want to create?” Should be ” Pivot Table” Select “Next”. …

Read the original: 
Summing unique values (where "unique" depends on multiple criteria …