How to suppress totals in DP (Demand Planning) Pivot View

[Former Member]

Anyone find a way to suppress totals in DP (Demand Planning) Pivot View?

In the Change Layout > Display options for Pivot Views is one for Display totals lines above the entries. We always have that unchecked but still get Totals in the Pivot View. If I do select that option I see no change and the option selection disappears when I go back in.

[Former Member]

Thanks Michel,

Yes we posted the OSS Message.

We recently stumbled across a Macro workaround solution using the Hide Rows and Show Rows macros. Is that the approach you were referring to?

Yes, the macro approach works but we found that it does have a moderate impact on performance.

We were hoping that SAP had a place to turn off the Totals in the Pivot View since they take up valuable realestate, significantly affect performance, and frequently lead to data entry errors if users mistakenly enter their forecasts on a Total Key Figure line.

[Former Member]

Hi Robert,

How did you managed to Hide Totals using Macro?

Can you provide a sample logic? We also have such business requirement.

Thanks,

Anup

[Former Member]

Anup,

Yes we can supply sample logic if you provide an e-mail address.

[former_member413022]

Hello Anup,

did you receive the sample logic from Robert. I have the same problem to suppress the totals but have no clue how to do it with the macro.

Best regards

Thoralf

[former_member413022]

Hi Robert,

I have a question regarding the topic:

Did you send the sample logic from Anup. I have the same problem to suppress the totals by drilling down but have no clue how to do it with the macro.

I also can't find any OSS note.

Best regards

Thoralf