as I am unexperienced and my deadline is approaching, I ask for help. I will display my problem in a simple way.
I have a data set of invoices. They have an invoice number as key ID, a document date, an amount and may have a clearing date.
I want to display on a timeline the open amount. An invoice is open from the day of the document date until the clearing date.
I somehow managed to create a master calendar. Of course I can't just create a diagram and accumulate values by document date as the invoices are cleared and then need to be removed from accumulation. Maybe that is an easy one and can simply be solved by an expert.