How to Find Similar Items in a Pivot

I have a database table in which all purchased Items are added. Many items are purchased by more than one suppliers.
I want to make a table which shows similar items purchased by various suppliers .
attached file is an attempt to get it. but it is not as I want to.
AT first I want to know the items from one specific supplier , then want to know that which are other suppliers for this Item?
In sample pivot it shows all items instead of only similar items.
please view the attached file and pivot table to understand my inquiry.
Best Regards.

This proposal adds a column (# Brands) to the table on the Source sheet.
The added column is populated using: =SUMPRODUCT(--(COUNTIFS([Item],[@Item],[Brand],T$2:T$7)>0))
T2:T7 reference the column headers (Brands) listed on the pivot table.
The pivot table is then set up as per the original with the # Brands used as a filter (values >=2 selected).
Let us know if you have any questions.

Originally Posted by JeteMc

This proposal adds a column (# Brands) to the table on the Source sheet.
The added column is populated using: =SUMPRODUCT(--(COUNTIFS([Item],[@Item],[Brand],T$2:T$7)>0))
T2:T7 reference the column headers (Brands) listed on the pivot table.
The pivot table is then set up as per the original with the # Brands used as a filter (values >=2 selected).
Let us know if you have any questions.

yes it works. Now how to sort it Largest to smallest according to Brand Numbers. that is the item with most suppliers should be at the top of the list.
Best regards.