How to hide the "Total: row in DP Planning book,

[Former Member]

Hello experts,

In the DP planning book, after loading the data, and "details all" one (or many) characteristic, on the top of planning book, or on the top of each detailed characteristic, it is a row Total or (sub tota), which is a sum of all the value in the key figures under each characteristic,

I want to hide this " Total" row, any possibility?

Thanks,

Kitti

[Former Member]

Dear All,

Thanks a lot, your suggestions solved my problem

Thanks,

Kitti

[Former Member]

Yes you can...

You will have to define a macro for that... there are standard conditions available for visibility of rows as well as columns..

You can hide a row or column...

You can also assign a colour to a particular row...

Refer to macro section......

You have to make it a default macro if you want it to get executed automatically everytime........

You can also make it start , level change macro if it meeds ur need....

[Former Member]

Hi Kittichai,

You should be able to achieve it with the following macro:

MACRO: Hide total row ( select "All planing objects" in settings for execution)

______IF

______Condition: agg level?

__________AGG_LEVEL( 'CHARACTERISTIC' ) = 1

______Row: XXXX( your keyfigure) ( properties select " Attributes change)

__________ROW_VISIBLE( 0 )

______ELSE

______Row: XXXX( your keyfigure) ( properties select " Attributes change)

__________ROW_VISIBLE( 1 )

______ENDIF

This hides the totals row when drilled down to details.make the macro as a default macro or a level change macro depending on your needs.

[Former Member]

Hi,

I have an additional query on the same reqirement. Can we have the settings valid for all the key figures in a dataview. Or we always need to specify the key figures for which we need to hide the totals row?

Regards,

Kedar Agarkar

[Former Member]

Hello,

You can accomplish this thru a macro. This macro should be a start macro and in macro definition, Settings for execution, please select Certain level (Aggr level).

Ashutosh