Skip to Main Content
Feature Request FR-1721
Product Area Application Builder
Status CLOSED

18 Voters

Add Row Totals for Interactive Report Pivot Tables

simon.joyce Public
· Aug 19 2021

Idea Summary
Currently the Interactive Report Pivot Feature only shows column totals, I'd like to get row totals too.

Use Case
For example if you a report that showed sale transactions which included the customer name,  category of purchase and amount purchased, you could create a pivot table to show the customer on each row, with a column for each category and the amount as the data point. Currently you could total the amounts by category (column) but you can't see the overall customer total, which would be the sum of the row amounts.

Preferred Solution (Optional)
Add an extra check box in the pivot wizard requesting to aggregate the row function and an aggregation selector.  It should be optional,  in some cases you may want the sum, in others the average etc so the different aggregation functions should be available, similar to the selection already available for the pivot column data already.

This request is likely a duplicate of FR-2532.

Comments

Comments

  • john.snyders APEX Team OP 4 years ago

    Title refers to interactive grid, which doesn't support pivot, and description refers to interactive report.

    I think the intent is that this idea applies to interactive report.

  • simon.joyce OP 3.9 years ago

    Hi John, Apologies, yes the title should read as interactive report. It is the pivot funcitonality in the interactive report that I would like to see enhanced.