cancel
Showing results for 
Search instead for 
Did you mean: 

Drilldown in a formatted crosstab header

0 Kudos
107

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
Active Contributor
0 Kudos

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.

0 Kudos

Hi Tammy,

Attached is the version we use.

Regards,

Syed

TammyPowlas
Active Contributor
0 Kudos

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

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Can anyone help?