Hi, I'm looking to create a component where I can track YTD sales amounts for each of my salespeople. I would like one component to show me the following columns: 1. User Name 2. Closed Deal $ Amount 3. Open Deal $ Amount.
The problem I am running into is that in creating a report, I can only use two columns, User Name and Amount. The problem I have when creating a custom view, is it must have a column for every deal, whereas I only want the User, Amount closed, and Amount open. Any help would be greatly appreciated. Thanks!