Hello, I want to showcase total for a specific metric rows in Quick Sight. Here is the example, I have 3 metrics, and I want to show total for only 4+ calls made rows from every group and not the total for all 3 metrics. Is it possible to do in Quick Sight? [image]

subtotal applied to the entire group and total to entire table. But you can make use of filters to see if you can achieve the desired results. Create a filter for Metric column and add filter condition to only include 4+ calls

How to Show Total for specific row grouping

Q&A

Karthik_Tharmarajan June 9, 2023, 4:43pm 3

Hi @Nikita, In addition to suggestion provided by @sakkamzn, you can also try using conditional formatting to highlight the total specific for a metric as shown below.

Regards,
Karthik

Topic		Replies	Views
Is there a way to apply conditional formatting in table totals? Q&A analysis , formatting , error , feature-request , quick-sight , calculations , Business-Intelligence-Engineer	4	137	April 24, 2024
Switch Measures on Tables Q&A quick-sight , visuals , calculations , Business-Intelligence-Engineer	9	87	November 10, 2024
Show a total number of rows with a filter Q&A analysis , quick-sight , calculations	2	2176	September 21, 2022
Custom Subtotals in Total Section on Pivot Table Visual... Is this possible? Q&A formatting , feature-request , quick-sight , pivot-table , Business-Intelligence-Engineer	5	227	June 10, 2024
Hide some columns in the total rows of a table Q&A quick-sight , pivot-table , tables	4	852	September 16, 2024

How to Show Total for specific row grouping

Related topics