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