Hello,
I have a crosstab with 4 sets of 3 column. All columns are measures in a TM1 cube with complex calculations in the cube for each of the 12 columns. One set is for <30 Days, the next for 30-60 Days etc. Each set then has 3 columns that are then in essence repeated for each set. For example, Days Late, Qty and Value. Thus we have 12 measures <30 Days - Days Late, <30 Days - Qty, <30 Days - Value, 30-60 Days - Days Late, 30-60 Days - Qty, 30-60 Days - Value etc.
I want to put a header in above all the <30 Days columns called "Less than 30 Days" and then rename the first column to be just "Days Late", the second to "Qty" and the third to "Value". Then repeat this for the next set.
Does anyone have any clue how to do this?
Thanks
John
drag in a crosstab space.
Thanks for prompt reply SDF. I tried that, but a Crosstab space seems limited to a single column. I couldn't work out how to make it span columns. Any ideas on that please? Thanks!
drag in (under) the columns you want to group by that cross tab space.
I knew there had to be an easy way!
So just to recap for eveyone else:
1. Drag in a Crosstab Space into a new column in the crosstab.
2. Drag the columns to be nested underneath the new Crosstab Space
3. Add a Text Item to the Crosstab Space and type in your label.
Thanks heaps for your help @SDF!
John