I have two metric columns and I want to hide the total column for one of them, but I can’t see how to remove the column header for that hidden total column. It’s the text in pink on the screenshot. Note this is showing the column’s data but hiding the data seems to have no effect on the header.
Hi @a15qxzz and welcome to the QuickSight community!
To my understanding, it’s currently not possible to hide one total and show another with the current pivot table setup in QuickSight.
The only work around I can suggest, although not quite sure they can be used in this scenario, would be to look in to the ability to setup a subtotal instead of a total so that you can switch one on and one off.
In terms of total’s options on pivot tables, I’ll mark this as a feature request to promote visibility to the support team.
Thank you!
Hi @a15qxzz,
While I’ve marked this as a feature request already, wanted to follow up and confirm if you had any additional questions?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @a15qxzz,
As we have not heard back any further, I’ll go ahead and close out this topic. You can keep an eye out for new features being implemented at the ‘What’s New’ section of the community. If you have any additional questions, feel free to create a new post in the community.
Thank you!