Hello to all and, in advance, I ask you for your indulgence for my english (i'm french) and if I submits you an 'obvious' problem.
I have a table which contains numbers of contract with a date of termination (informed or empty if it is always active). I try to create a graph with in abscissa 12 months. The data are to be calculated over 12 months sliding (for example the point corresponding to May 2014 has to count contracts between 01 june 2013 and 30 may 2014).
It has to contain:
2 histograms (one a year on 2013 and 2014) representing the active contracts in the end of every 12 months months sliding (= date of termination 'empty' or > of the month of the dimension).
2 curves (one a year on 2013 and 2014) representing the number of contract cancelled during the same period of 12 sliding months.
I want to make the calculations "in the air" directly in the expressions to keep the detail of lines in order to be able, if needed, to identify contracts instead of passing by a facts table containing a month pre-calculated aggregates.
Is this possible? Do I have to use an external calendar and in this case how generate it and connect i so that it works?
Thank you for your help, any solution will be welcome because I have to finalize quickly this calculation.
