I did now extensive research and had several discussions with HubSpot support, but this feature is not available it seems. I am working in a business where a deal has several payment milestones. The only way how I can do this now, is to create additional deals, which makes my pipeline messy. e.g. Implementation deal of 100k - we get 20% upfront: 20k - 25% Milestone 1 - 35% Milestone 2 Some deals have more milestones than others. My overall goal is to have an overview, when which payment is planned to arrive, so I can do better forecasting. I would like to create a pivot table where in the rows are my deals. The columns are the months (or weeks). Then I see for each deal, the payment milestones in the respective month. In the bottom is added for each month, how much money will arrive. In the last column on the right is the total deal value und in the last row and last column is the total deal value summed up. To have something like that in a bar chart would also be nice, but a pivot table is the bare minimum. Would be possible, if I can associate a date with a fraction of the overall deal value. After browsing in the community and here, it seems that a lot of companies have this issue.
...read more