hello
you will find attached a sample application with :
a fact table containing
an id (id_ot)
a date (id_calendar)
2 qty (qty1, qty2)
a dim table with
an id (id_ot)
a budget value (Budget) available between Begin_Date and End_Date
a End_Point value
a calendar table
a sheet containg a graph showing
by month (Mois)
Qty1 and Qty2 for each month
End_Point which is the total amount at the end of the year
All this works perfectly ...
now the problem
I want to display each month the Budget value which is the sum of all Budget for the id_ot such as Begin_Date<=id_mois<=End_Date
I would not like to create another table table with the list of months by id and containing the budget value
Any idea ?