Where "MonthStart" and "MonthEnd" are fields from a connected Calendar
When i filter by a special Date i get the right value for this Month. I get all values from the Table where startDate is less then the chosen Date(MonthStart) and endDate is higher than the chosen Date(MonthEnd)
I want to show a Chart with Dimension "Month".
for Oct MonthsEnd = "2014-10-31" and MonthStart = "2014-10-01"
for Sep MonthsEnd = "2014-09-31" and MonthStart = "2014-09-01"
But what it does right now is when i make a full accumulation, for every dimension (oct, sep, aug...) it allways uses MonthsEnd = "2014-10-31" and MonthStart = "2014-10-01".
Please can somebody help me to achieve this problem.