SAP: Remove the grand totals and keep the sub totals of an ALV Tree

Tags:
ALV TREE
SAP
Hi Experts, I have a requirement of creating an ALV Tree from scratch. (Please see attachment). Problem is if I remove the grand totals, the sub totals are also removed which is not the requirement. They want to keep the subtotals and remove the grand totals at the top most of the report. Another question is, how to keep the ALV tree expanded all the time. No need for user to drill down the folders and subfolders anymore. Is it possible? Thanks, JC


Software/Hardware used:
sap
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen

    Assuming you are asking for pivot table. If yes, click anywhere in the pivot table to see the tools on the ribbon. Now click design, grand totals. Now you can click/ select option like, off for rows and columns Or on for rows and columns Or on for rows only Or on for columns only. If you don’t want to show grand totals for rows or columns, uncheck the show grand totals for rows Or show grand totals for columns boxes on the totals & filters tab in the pivot table options. Please look at here, https://support.office.com/en-us/article/Subtotal-and-total-fields-in-a-PivotTable-report-173f5b30-b546-4293-87d2-aee638f74e7d

    To see the above URL, browser supports is necessary.

    138,560 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: