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.