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
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.
Discuss This Question: 1  Reply
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.