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?
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
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.
Glad it worked. You're welcome.
Regards,
Bark