HowTo hide total row when disaggregate data

[Former Member]

Hello everyone!

I need to hide the total row that appears when I disaggregate data for each characteristic.

Example:

Planning View has 3 Key Figures (Forecast, Initial Stock and Final Stock) and 3 Characteristic (Segment, Location and Product).

I select all information, Planning View shows me the 3 KF with their values.

When I choose the characteristic "Segment - Details (all)", the Planning View shows me for KF one single total row (for Segment).

When I chosse another characteristic beside "Segment" like "Location - Details (all)", the Planning View shows me for each KF three totals rows (one for Product, other for Product/Location and other for Location).

Can I hide these all totals rows?

I tried to find some answer in this forum but I only found about "total column".

Thanks and best regards.

Mariano.

[Former Member]

Hi Mariano,

The "Total" row in a drill down scenario can be hidden by using a macro like:

IF

New condition

ACT_LEVEL = '0'

Row: <the key figure in question> =

ROW_VISIBLE( 0 )

ENDIF

where properties for row have to be set to Attribute Change. This macro can then be assigned e.g. to level-change event.

Thanks and Regards,

Nithin.