Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have set up a calendar with min day Today() and max day the max expected invoice data of a sale. I want to show the full value of that invoice spread over the number of months or quarters between today and that date which will be different for every invoice. So to see an average value coming in each month from that invoice. Ideally I would like to show this on a pivot table with month and quarter and year at the top.
see if this link helps
Distribute amount by month using total Amount, start and end date