Hello,
I am trying to build an opportunity pipeline workbook. I want to see how many opps we have won or lost that were created this year. If they were won, I would like to be able to pull in the invoice amount of that sale and if lost I would like to show the loss reason.
For whatever reason I am having a hard time pulling this information. Especially the Lost Opps. Any suggestions?