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,

Re your last comment in which you state:

"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."

Judging by your screenshot you are now trying to merge two merged column headers into one single column header (stretching across multiple columns?

I have no issue in merging multiple header cells in a cross table, with or without using tricks. I am afraid I do not fully understand your question. Could you please provide more detail and more illustrative screen shots, maybe based on an Excel spreadsheet example with some explanations around it?

It would also be helpful if you did not open multiple threads on the same question. Please keep to one thread per question and close those that you feel have already been answered.

Kind regards,

Tom

[former_member402770]

Hi Tom,

Judging by your screenshot you are now trying to merge two merged column headers into one single column header (stretching across multiple columns?

Yes that is exactly what iam looking further assistance.

Thanks,

Dinya