Skip to Content
Sep 17, 2018 at 12:12 PM

Drilldown in a formatted crosstab header

73 Views Last edit Sep 17, 2018 at 01:39 PM 3 rev

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?