The reports always show deals created per month, or lost per month. I just want a total number of deals existing in the pipeline that month, or at the end of the month. Please help!
I would suggest considering Coupler or Flatly to build a data pipeline.
You can read more about building a data pipeline for Pipedrive in this article.
Once done, you can build a view of your sales pipeline.