Forum Discussion
Helper II2 different table column values from 1 field
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?
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
3 Replies
- Greg_Deckler
Community Champion
gilmore_staci Use a Matrix visual and use Affiliation as the Columns?
gilmore_staciGreg_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
- gilmore_staci
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
