Amazon QuickSight is excited to announce the launch of Custom Total feature for Tables and Pivot tables. This new functionality enhances user flexibility and streamlines the process of defining calculations. Users now have the convenience of specifying calculations such as Sum, Average, Min, Max, and None (Hide) from a predefined list to compute totals in table/pivot table charts with a straightforward, one-click method within the user interface. This eliminates the need for users to create intricate calculation formulas for accurate data retrieval at both the row level and total calculation. Additionally, the feature is accessible through public API and is supported by AWS CloudFormation. For further details, visit here.
Source:: Amazon AWS