It's pretty close, but there are several problems I can't seem to solve:
1) how can I have a subtotal on each row that shows the number of products in that particular store?
2) how can I have a subtotal on each column that shows the number of stores that product is in?
3) how can add the rank column that is sortable? (This is just a column out of the db... it's not calculated)
4) since I'm adding the location names from the locations table with no concept of Rep when I try to filter by Rep it successfully removes the sales data (the dots go away in the visual), but the stores that don't belong to the Rep remain. How can I solve that?
Thank you in advance for your help! I'm super stoked to learn more about this platform!