Discontinous crosstab issue

[backhandx]

Hi all,

I have a problem with discontinous Crosstab. This is the context:

Suppose I have a Time table with 2 column:
   - date columns with values: 2016/01, 2016/02, 2016/03, 2016/04 ....
   - last months column with values: 0 ,-1 ,-2 ,-3, -4, -5 .... the 0 value corresponds to current month, -1 : last month and so on
   
I have a Time dimension with two hierarchies.

- Date Hierarchy : populated from the daet column.

- the last 4 months of the year: M (current months), M-1, M-2, M-3, populated from the last months column

The users want to create dynamic report to compare for exemple the revenue in 11/2016 with the current months. So, they want to create crosstab with 2 members in the clumns: 2016/11 from the hierarchy Date and the M ( current months) member from the calculated month. The problem is when generating the report I get no data. I think because Cognos apply a fitler on time table like:  Time.date =  2016/11 and time.last_month = 0.
I want to know how it can be done to display the two members in the same crosstab. Is it possible to make a change in the Framework the way that Cognso generate Or condition instead of AND.

Thanks for you reply.