Posted On: Sep 26, 2023
Amazon QuickSight introduces the ability to add contextual row subtotals in pivot tables for easier understanding and improved presentation. Authors can now customize subtotal labels by appending the group name, enabling clearer association and understanding. For instance, if the current group is "North America," users can rename their subtotals as ‘North America Total,’ ‘Total for North America,’ or ‘Total North America.’
This feature is especially valuable for large tables or fields with high cardinality, preserving contextual relevance even when subtotals are not immediately visible in the same view. Its significance shines in intricate multi-page, multi-level reports, preventing the loss of meaningful insights when related groups are not immediately evident. For additional details click here.
The new contextual row subtotal for pivot tables will be available in Amazon QuickSight Standard and Enterprise Editions in all QuickSight regions - US East (Ohio and N. Virginia), US West (Oregon), Asia Pacific (Mumbai, Seoul, Singapore, Sydney and Tokyo), Canada (Central), Europe (Frankfurt, Ireland and London), South America (São Paulo) and AWS GovCloud (US-West).