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?