2 different table column values from 1 field

[gilmore_staci]

I'm not even sure what this would be called.  I have a field called Affiliation, the values are Customer, Dealer, Company, all associated with a site name

In my table I want the site name, #of Customers, # of Dealers

Example:

Site Name        # of Customers             #of Dealers

1                       23                                 13

2                       11                                  5

3                        7                                   16

How do I filter the Affiliation field to get # of Customers column and still have the Dealer option for the # of Dealers column?

[gilmore_staci · Accepted solution]

I figured it out, I needed to add Country to the Rows, then expand all and turn off the stepped layout under Row headers format

[gilmore_staci]

@Greg_Deckler almost there, I can't add any other columns or it give me that data for each affiliation in another coulmn, so if i add location, it give me location for customers and location for dealers,  I only want location for each site

[Greg_Deckler]

@gilmore_staci Use a Matrix visual and use Affiliation as the Columns?