Hide some columns in the total rows of a table

[ss49919201]

Is it possible to hide some columns when displaying table totals?

Consider the following table as a basis.

date	CountA	CountB
2023-07-01	1	2
2023-07-02	1	2
2023-07-03	1	2

Displaying the total would be as follows.

date	CountA	CountB
2023-07-01	1	2
2023-07-02	1	2
2023-07-03	1	2
total	3	6

I want to not display total values for certain columns only.

date	CountA	CountB
2023-07-01	1	2
2023-07-02	1	2
2023-07-03	1	2
total	3	6

For example, hide only column B and expect the following.

date	CountA	CountB
2023-07-01	1	2
2023-07-02	1	2
2023-07-03	1	2
Total	3

[gillepa]

Hi @ss49919201

currently you cannot enable/disable totals for select columns. There are new enhanced table and pivot capabilities coming out soon that get you closer to what you want. I can take this down as a feature-request

Hope it helps,

[Fotis_flex]

Hallo @gillepa . Has this feature been developed in QS? I really need this too! Is there under schedule? I would appreciate an update

[gillepa]

@Fotis_flex

please check out

Introducing advanced formatting options for pivot table totals and subtotals...

Amazon Quick Sight launches contextual row subtotals for pivot tables

Amazon Quick Sight 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 is a companion discussion topic for the original entry at https…

Amazon Quick Sight launches Custom Total for Table and Pivot table charts

Amazon Quick Sight 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 int…

GL

[balawatt]

Hi! @gillepa

. I wanted to know if totals can removed for ‘Actuals’ column and not for ‘Sub Score’. this is similar to the original request on this thread. Thanks!