Drilldown in a formatted crosstab header

[former_member400489]

Dear Gurus,

I have a requirement. I have a formatted Analysis Workbook, which has a output as in attachment . Initial output of the workbook would contain GL Account, Actual, Budget and Variance ( A - B) columns. Header of the crosstab is formatted as given below. Now the user wants to add (drill down) Cost Centers to this report. In that case, the formatting wouldn't stay as it is, considering, formatting is custom formatting.

Is there any way, i could sustain the formatting of the header, irrespective of a row / dimension is added / removed (or) it is changed from showing only text, to showing Text/Key. Could anyone of you share your expertise in achieving this?

Regards,

Syed

[TammyPowlas]

Hi - which version/SP of Analysis Office are you using?

To be honest, I am not following this requirement. Would you please share screen shots? Use the image icon to upload.

[former_member400489]

Hi Tammy,

Attached is the version we use.

Regards,

Syed

[TammyPowlas]

Hello Syed- I mean screen shots of your requirement. Thank you

[former_member400489]

Hi Tammy,

I did attach a screenshot in my original message. If you missed it, below is the same for your reference.

ao-formatted-output.jpg

Regards,

Shujaath

[former_member400489]

Can anyone help?