My problem is the spreading of the line item amounts across the start and end dates (which would have been clear w/o the circrefs - i apologize). Here is a better annotated working version.Gregg Wolin
Many things are possible
... after You would know exact ... what? - without etc
One sample ...
There were some/many 'Circular References', but I skipped those.
Thanks - but it still isn't spreading the costs between the Start Date and End Date. It needs to divide the amount of the line item by the number of months between the start and end date and show that amount in the requisite month. i.e. For a $600k line item, if the Start Date is June 2020 and the End Date is 12/31/2020 then there should be 100k in each month between June and December 2020.
Sorry Again - I forgot to repost the file (notes inside). If its not do-able with a pivot table, then vba or other options would be fine.Gregg Wolin
Do You still write about Pivot-table?
For me, Pivot-table could show values from data many ways.
But ... Your way to show those values could show other ways ... eg by code.
but but ... then You should able to write very clear, what would You want to see?
Exactly what i was looking for!Gregg Wolin
Other variation by the 2nd [ Do It ]-button...
Thanks! I guess VBA was required after all.