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 · Accepted solution]

Hi Dinya,

You cannot merge two merged header cells into one single merged header. As a workaround you may want to consider creating a dummy table that just shows your desired headers. Make sure you have fixed column width for your columns in the "real" table. Then model a dummy header table as follows:

1. Insert table and then add as many columns as you need. In the example below (see screenshot) I need just three columns for my three months (Jan to Mar) plus an additional column for the vertical axis in my crosstab. Add more columns if you require more.

   

2. Then add another header row on top of the existing
3. Select all your body cells and in Format Cell... remove the border and choose no color in appearance.
4. Now merge the top header cells into one cell and enter your merged column header name
5. For your months you will need to apply a formula for each of the three header columns, e.g. =[Month] Where([Month="1"). Otherwise you will get a #MULTIVALUE error.
6. Now move your dummy header table on top of your "real" table. Go to Format Table Layout and choose the same horizontal distance as your cross table. For the vertical alignment you choose 0 cm from the top edge of your cross table.

   

This workaround does not work if you need your column headers dynamic, i.e. where your first month in the crosstab changes according to possible user input at query runtime. In this case you would have to think about additional calculations to resolve the header names dynamically.

Kind regards,

Tom