Reading future measures in a crosstab - solved

[MikeG]

Using Cognos Express 10.2.1 reading from TM1 cube

I have to create a crosstab report as follows

                                        Month1    Month2   Month3   Month4
             Retail                      0             3           2             4
             Stock                      8              5          3

             Measures                 3              2          1


Measures is a query calculation that looks at the stock (for Month1 8) and calculates how many months retail will be covered (ie Month1 Month2 Month3 and gives the no of months in this case 3

My report looks like this

                          < #Month#>
             Retail                     
             Stock                     

             Measures     

Month is a level of many members a filter picks out the current year's months       

I have tried tuple sets but with no success
    I guess you would have an if else statement like this

if (value (tuple([period], [retail], [ month 1]) < value (tuple ([period], [Stock], Month1) them Measures = 1

    else

        if (value (tuple([period], [retail], [ month 2]) < value (tuple ([period], [Stock], Month 2) them Measures = 2....

It is how to reference Month 1 2, 3, 4 etc that is causing me a problem

any ideas gratefully received


I solved this by doing the calculation in the TM1 cube