Skip to Content
0
Former Member
Dec 09, 2014 at 11:42 AM

Formatting Specific Lines where two dimensions in Rows.

19 Views

Hi,

I have a report but Part of the report I want it to be set to 2 dp and the rest 0 dp - totals I want bold generally. See details below. There are three sections to the report. The columns are static and the rows have Entity (restricted to show Member only - Enity A, B, C) and Column (member and child for Account A)

- I need to make Entity B to 2 DP - which i can do via a property. All Entity B have a property which i can use to make it 2 dp.

- I also need to make totals bold - the way i do this is via the hierarchy setting on the Formatting Sheet. Top nodes are bold.

The problem i have is that the first DP entry on the formatting sheet overides the the bold setting and the bold setting disappears.

Any ideas on how to get around this? I have tried local formulas but i seem to only be able to add them against the dimension Account and it repeats automatically so i cant seem to specify a single line under Entity B.

Thanks,

Table

Hierarchy

Attachments

Table.JPG (81.3 kB)
Hiear.JPG (11.6 kB)