cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting Specific Lines where two dimensions in Rows.

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Leo,

Can you explain what do you mean by


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.

Former Member
0 Kudos

Hi,

I want all Entity B rows to be set to 2 DP. Rest of report zero DP.

As you can see from the screenshot I want the totals to be set to be bold. i.e. Accounts A row which is the parent of Accounts 1,2,3.

Cheers,

former_member186338
Active Contributor
0 Kudos

Shrikant_Jadhav
Active Contributor
0 Kudos

Do "Add formatting o specific member / property.

As shown in screen shot

Former Member
0 Kudos

Hi,

Sure, but the problem is that this overrides the totals setting which is the following.

Totals Bold and border

The report then looks like the following - bold disappears.

former_member186338
Active Contributor
0 Kudos

Yes, Leo,

Sections below override upper formats. You have to define bold formatting for ACCOUNTSA

Vadim

former_member186338
Active Contributor
0 Kudos

If your report have this structure:

BASMEMBER1

...

BASEMEMBERN

PARENTMEMBER

You can format totals after Entity B using property CALC=Y

Vadim

former_member186338
Active Contributor
0 Kudos

Ups, simple solution - for Entity select only Number Format!

Shrikant_Jadhav
Active Contributor
0 Kudos

do formatting only for entity B as shown in screen shot

former_member186338
Active Contributor
0 Kudos

Vadim

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Hi Leo,

What do you mean by "DP"?

Vadim

Former Member
0 Kudos

Sorry - meant Decimal Places