Hello, I really appreciate your work on mondrian and analysis service.
I have the following problem. I have a table with fields like 'initial stock', 'time_id' and 'final stock' and I need to aggregate these stock fields according to the time period selected in the filter dimension in such a way that initial stock is the sum of initial stocks corresponding to the first time_id and that final stock is the sum of final stocks corresponding to the last time_id, each changing dinamically through the time dimension filter.
Is it possible to have such a behavior with mondrian aggregator?
Could you please help me?
I tried with calculatedMember and with MeasureExpression but without success.
Thanks in advance,