I have a requirement to create a crosstab report which spans upto 9 pages.
My datasourcse is tm1 dimensional cube.
My rows are same across all 9 pages only difference is that my value of crosstab changes across 9 pages.
So i created a set of 9 values that is set([sales volume], [contribution] etc.)
and created a section report on the basis of that.
My columns are VERSION of actual, budget.
So it filters perfectly on the basis of set created.
Problem:
I was asked to add different columns for different values in set section.
that is volume to sales and contribution to sales which are calculated in tm1.
If I drag those elements in the crosstab, the values retrived are null since the section filters all columns including contribution to sales.
If I nest it separately.
columns -
contribution | Contribution to sales
Actual | Budget| Actual
rows
the values are retrived correctly.
But If I sectionwise on contribution the value for contribution to sales is retrived as null
since it is taking in the context of contribution of contribution of sales and actual.
Has anyone came across this issue?
I really don't want to create 9 pages :'( :'(