Pivot Table Filters

[reedersketer]

Good evening,
I have been puzzling on this for the last couple of days, and feel like this should be easy, but am totally missing it. I have a set of data which includes 5029 computer names and the Adobe software that is installed on that computer. I have been asked to provide a report, showing just the computers that have titles Bridge, Illustrator, InDesign and Photoshop installed. The computers must have the at least all 4 titles. If there are other titles, those also need to be visible, but if the computer does not have those 4, they do not need to appear in the list. Of course, if I filter the titles to just those, I will end up with computers that do not have all 4 loaded, and will lose visibility to other titles loaded. Help, please. I have attached an example of the type of data I am working with. The actual data has a total of 18078 rows of data.
Additionally, I have been asked to provide a list of computers that have only one title listed. I have cheated that report, but know that there should be a way I can filter that as well, but could not figure that out.

I appreciate any help provided. This may not be a pivot issue, but I am at a loss.

[benishiryo]

hi there. you might have to add in an extra column in your source data with this formula:
=AND(COUNTIFS(A:A,A2,B:B,"Bridge"),COUNTIFS(A:A,A2,B:B,"Illustrator"),COUNTIFS(A:A,A2,B:B,"InDesign"),COUNTIFS(A:A,A2,B:B,"Photoshop"))

then filter TRUE for this in your PivotTable

[xlnitwit]

Hi,

In your actual data, could the same computer show the same Adobe software twice?

You could simply set an autofilter on the page and filter those four columns to exclude blanks.

[reedersketer]

Thank you so much! This worked fantastic!

[bahaa555]

Dear gents,

Please i need your help. I have pivot table with date column i want to show subtitle in the filter. please see this image2.png i want the filter to be organized like this 1.png.

Regards,

[xlnitwit]

Hi,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[bahaa555]

sorry for this.
How to start a new thread ?

thank you

[xlnitwit]

Click the 'Post new thread' button at the top of the forum page when you are looking at the list of questions, not when you are in a specific question already.

[bahaa555]

i dont have this tab maybe i have to pay for it ?

[xlnitwit]

No, this part is all free. If you click this link you should see the button to post a new thread at the top left hand side of the page- https://www.excelforum.com/excel-charting-and-pivots/

[bahaa555]

thank you very much