Calculate Totals excluding values of hidden column

[heitham]

I have a crosstab based on a relational datamodel.
In the rows the attribute for Products nested with measures, in the columns the attribute for the Years.
The requirements for this report are to show the years <2013 followed by a Total column. Additional a column should be displayed for YTD after the Total column.

I tryed it with two queries, one for the years < 2013 the other one for 2013. That works but the report does not show a proper crosstab, because products not exsisting in 2013 will retrieve less datasets.

When trying to build the requirements in one query, I have a problem by hidding the year 2013 and getting the right totals.

Has anyone a hint, how to get the issue fixed?

Thank for your support
Heitham