Dynamic column Header Label Repeating

[former_member402770]

capture.jpgHi Experts,

Iam trying to merge dynamic column header "label".

The cross tab column added with Multiple list values as "AFRVP", "EAPVP" as dimension. Inserted an row above to add "Label". but Label seems tobe repeating as with column dimension, Attached screehsot for reference.

Could you please help to merge repeating Label to single "Label" and align center.

Thanks,

Dinya

[Tom_N8]

Hi Dinya,

Ayman's solution does not work in cross tables. For cross tabs, you will need to apply a little trick:

1. Create a dummy variable with ="Text".
2. Add the dummy variable to the header of your cross table.
3. Now apply a break on this variable.
4. In Manage Breaks untick "Break Footer" and "Merge" duplicate values.

Done. I found this here. It works.

Regards,

Tom

[former_member402770]

Hi Tom,

Many Thanks! it worked.

In the similar lines i wanted to this merged dummy column variable with another merged column text to result as single Text

Could you please help on this.

Below screenshot where 1st Actual displayed is merged using above little trick solution and this needs again to merge with another merged column value "Actual" to display as single "Actual" . Here merge option is gryed out so couldnot able to merge.

Thanks,

Dinya

[ayman_salem]

Hi Tom, it work in cross tables if you have two measure (as in this example "work and status") in the body of the cross table.

However, if you have only one measure, your solution is more appropriate