SOLVED

Pivot tables and duplicate data

%3CLINGO-SUB%20id%3D%22lingo-sub-2228127%22%20slang%3D%22en-US%22%3EPivot%20tables%20and%20duplicate%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2228127%22%20slang%3D%22en-US%22%3E%3CP%3EGoal%3A%20When%20I%20create%20a%20pivot%20table%20I%20select%20to%20know%20which%20location%20and%20what%20has%20not%20been%20signed.%20The%20idea%20is%20to%20have%20the%20pivot%20table%20show%20me%20how%20many%20unsigned%20contracts%20a%20location%20has.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%3A%20The%20orders%20in%20the%20spreedsheet%20show%20in%20more%20than%20one%20line%20as%20their%20products%20are%20listed%20out%20per%20row%2C%20this%20makes%20the%20pivot%20table%20think%20there%20are%20way%20more%20unsigned%20orders%20that%20there%20actually%20are.%20If%20you%20check%20the%20practice%20excel%20sheet%2C%20I%20attached%2C%20you'll%20see%20what%20I%20mean.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20think%20what%20I%20want%20to%20do%20is%20possible%2C%20as%20I%20cannot%20change%20how%20the%20orders%20are%20listed%20out%20since%20the%20excel%20sheet%20is%20created%20from%20a%20software%20program%20we%20use%20that%20shows%20us%20around%20800%20rows%20of%20results.%20So%20I%20figured%20I'd%20check%20with%20this%20community%20of%20bright%20minded%20individuals%20to%20see%20if%20there%20was%20so%20kind%20of%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2228127%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Goal: When I create a pivot table I select to know which location and what has not been signed. The idea is to have the pivot table show me how many unsigned contracts a location has.

 

The issue: The orders in the spreedsheet show in more than one line as their products are listed out per row, this makes the pivot table think there are way more unsigned orders that there actually are. If you check the practice excel sheet, I attached, you'll see what I mean.

 

I don't think what I want to do is possible, as I cannot change how the orders are listed out since the excel sheet is created from a software program we use that shows us around 800 rows of results. So I figured I'd check with this community of bright minded individuals to see if there was so kind of way.

2 Replies
best response confirmed by NoraJJ (Occasional Contributor)
Oh wow, it is possible. Thanks Detlef, I just learnt a great new feature in excel.