Help with Complex (to me) Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2145057%22%20slang%3D%22en-US%22%3EHelp%20with%20Complex%20(to%20me)%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EPlease%20bare%20with%20me%20on%20this%20explanation!%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EGoal%3C%2FU%3E%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20data%20that%20I%20need%20to%20display%20(so%20far%20I've%20been%20using%20a%20Pivot%20Table)%20%3CU%3Ethe%20owner%3C%2FU%3E%20of%20a%20certain%20property%20(possibly%20multiple%20properties)%20with%20%3CU%3Ethe%20address(s)%3C%2FU%3E%20below.%20In%20another%20column%20I%20need%20it%20too%20tally%20up%20the%20%3CU%3Enumber%20of%20properties%20owned%3C%2FU%3E.%20Then%20I%20need%20to%20be%20able%20to%20filter%20out%20those%20numbers%20(Ex.%20only%20display%20owners%20with%202%20or%20more%20properties)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EHelp%3C%2FU%3E%3C%2FP%3E%3CP%3EHOW%20DO%20I%20DO%20THIS%3F%3F%20I%20have%20tried%20and%20tried%2C%20but%20I%20think%20this%20is%20where%20my%20knowledge%20of%20Excel%20stops.%20I%20think%20that%20the%20problem%20is%20that%20I%20cant%20filter%20out%20the%20number%20of%20properties%20owned%20because%20the%20number%20displayed%20is%20just%20a%20count%2C%20not%20actually%20a%20calculation%3F%20Please%20Help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2145057%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2145246%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Complex%20(to%20me)%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145246%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F970384%22%20target%3D%22_blank%22%3E%40ImBrite%3C%2FA%3E%26nbsp%3BPerhaps%20the%20pictures%20below%20help%20(taken%20on%20Excel%20for%20Mac%2C%20similar%20for%20PC%20version)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-18%20at%2006.25.11.png%22%20style%3D%22width%3A%20424px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255692iA18C4C356ECF9AB5%2Fimage-dimensions%2F424x260%3Fv%3D1.0%22%20width%3D%22424%22%20height%3D%22260%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-18%20at%2006.25.11.png%22%20alt%3D%22Screenshot%202021-02-18%20at%2006.25.11.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-18%20at%2006.25.35.png%22%20style%3D%22width%3A%20279px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255690iF39707234D8911E0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-18%20at%2006.25.35.png%22%20alt%3D%22Screenshot%202021-02-18%20at%2006.25.35.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-18%20at%2006.25.56.png%22%20style%3D%22width%3A%20388px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255691iAEE2FC5CC2E20843%2Fimage-dimensions%2F388x177%3Fv%3D1.0%22%20width%3D%22388%22%20height%3D%22177%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-18%20at%2006.25.56.png%22%20alt%3D%22Screenshot%202021-02-18%20at%2006.25.56.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Pivot%20Table%2C%20you%20can%20press%20the%20filter%20button%20where%20it%20says%20%22Row%20Labels%22.%20Choose%20%22Filter%20by%20value%2C%20Equals%20and%20enter%20the%20number%202.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Please bare with me on this explanation!

 

Goal

I have a list of data that I need to display (so far I've been using a Pivot Table) the owner of a certain property (possibly multiple properties) with the address(s) below. In another column I need it too tally up the number of properties owned. Then I need to be able to filter out those numbers (Ex. only display owners with 2 or more properties) 

 

Help

HOW DO I DO THIS?? I have tried and tried, but I think this is where my knowledge of Excel stops. I think that the problem is that I cant filter out the number of properties owned because the number displayed is just a count, not actually a calculation? Please Help!

1 Reply

@ImBrite Perhaps the pictures below help (taken on Excel for Mac, similar for PC version):

Screenshot 2021-02-18 at 06.25.11.png

 

Screenshot 2021-02-18 at 06.25.35.png

 

Screenshot 2021-02-18 at 06.25.56.png

 

In the Pivot Table, you can press the filter button where it says "Row Labels". Choose "Filter by value, Equals and enter the number 2.