Deletion of Total(Aggregated Sum) rows in planning book

[Former Member]

I want to get rid of 'Total(Aggregated Sum)' rows in planning book tables.

'Total' line is useful but too many lines are uncomfortable for planners, so we're searching for the method not to use it.

If you know how to configure or use macro for it, please let me know.

Thank you,

HyeRee

[Former Member]

Hi,

I have similar requirement but haven't found solution yet. Let me know if you get answers.

Thanks,

Niranjan

[Former Member]

Hi,

I can delete totals, but I can´t delete subtotals.

Macro Delete Totals

IF

New condition

PLOBS_FOR_LEVEL( ACT_LEVEL ) = 1

Step 1 iterations

ROW Ratio 1

ROW_VISIBLE( 0 )

ROW Ratio 2

ROW_VISIBLE( 0 )

...

ROW Ratio n

ROW_VISIBLE( 0 )

ENDIF

This macros works ok to deleting row totals.

Raúl.

[Former Member]

Thank you for your valuable answer. It seems to be a solution for it!!

HyeRee