I need to create a chart/table that will provide me detail by tenure. I have attached a sample of what I need in excel. I have also attached the qvw with my sample data.
I have sales agents that do presentations for customers and I need to analyze to see who is not closing those presentations into a sale. I need to breakdown my analysis by new and old agents...so I need to take into consideration their hire date compared to their Sale Submit Date.
Any help will be greatly appreciated....thank you! Please see my attachments.
