[SOLVED] Formatting levels in a crosstab

[RubenvdLinden]

I have a crosstab report based on a PowerCube with a 3 level hierarchy, so I have set up level indentation to distinguish the detail rows from the totals. E.g.:

41 - Personnel                                    10.000
   401 - Administrative Personell           5.000
       401001 - Accountant                     4.000
       401002 - Secretary                        1.000
(etc)

However, the report contains a lot of detail rows and is pretty hard to read. The key user of the report now asks if I can adjust the formatting of the level 1 and 2 rows (both members and measures) to make the report easier to read. I'm having a hard time to figure out how to do this. Is it possible?

[Bark]

I don't really understand what you want to do; how do you want it to look like?

Anyway, if you don't want to use the built-in functionality for indenting, you can always use conditional formatting based on a variable which expression contains the "Level". i.e. create a new data item with "ordinal(level(currentMember([Hierarchy])))" and then apply the formatting you need.

Hope it helps.

Regards,

Bark

[RubenvdLinden]

I want to give the first 2 levels of the member a different formatting, e.g.

41 - Personnel                                    10.000
   401 - Administrative Personell           5.000
       401001 - Accountant                     4.000
       401002 - Secretary                        1.000

Your ordinal data item works perfectly, thank you.

[Bark]

Glad it worked. You're welcome.

Regards,

Bark