New row and column interactivity choices for tables and pivot tables in Amazon QuickSight – Half 2

Amazon QuickSight is a fully-managed, cloud-native enterprise intelligence (BI) service that makes it simple to create and ship insights to everybody in your group and even along with your prospects and companions. You can also make your knowledge come to life with wealthy interactive charts and create stunning dashboards to share with 1000’s of customers, both instantly inside a QuickSight software or embedded in internet apps and portals.

Within the earlier put up on this two-part collection, we mentioned drag handlers to change top and width for rows, columns, and desk headers. Now, let’s have a look at a few of the new interactivity choices for rows and columns for tables and pivot tables.

Conceal or present fields for authors

Beforehand, authors may solely cover fields in tables. Now we’re extending this characteristic to pivot tables as properly. Authors can cover rows, columns, and values from both the sphere wells or from the column or row discipline headers in pivot tables. For simpler identification, hidden fields are indicated with a cross eye icon; you may revert them again to seen utilizing the Present all hidden fields possibility.

Let’s have a look at a few of the use instances the place this might be useful:

  • Outline actions on a pivot desk and conceal fields to save lots of actual property – Typically, you might need to cover fields in a pivot desk whose sole goal is to allow actions, like opening one other webpage and go this hidden discipline as a parameter.
  • Use hidden fields to outline a customized kind order – You may outline a customized kind order to your pivot desk utilizing hidden fields, for instance, defining a particular order to your PNL stories.
  • Show two tables aspect by aspect as a single visible – Within the following instance, we present gross sales by nation, the place desk 1 shows the final 4 weeks of information and desk 2 shows month-to-month knowledge from the final 4 weeks.
  • Create butterfly tables – One other variation of displaying tables aspect by aspect is to create butterfly tables the place values are displayed on each side of the dimension. It is a nice technique to examine two units of values. For instance, you may examine the present month vs. a full 12 months of information.

Export hidden fields for authors and readers

Not solely can authors cover fields, they will additionally management the power for readers to export knowledge together with the hidden fields or with out them. When publishing the evaluation, authors have the brand new possibility Allow export of hidden fields on supported visuals. When you choose this feature, readers are in a position to embody hidden fields when exporting their knowledge. The default setting is to maintain this disabled and solely permit readers to export seen knowledge.

Primarily based on the completely different eventualities, the next choices present up for exporting knowledge to CSV and Excel from tables and pivot tables.


On this put up, we seemed on the new functionality of toggling row, column, and worth discipline visibility on tables and pivot tables. We additionally mentioned the varied use instances for hiding fields and the brand new exporting choices related to discipline visibility, which could be managed by authors. To study extra about desk and pivot desk formatting choices, check with Formatting tables and pivot tables in Amazon QuickSight.

Check out the brand new characteristic and share your suggestions and questions within the feedback part beneath.

In regards to the creator

Bhupinder Chadha is a senior product supervisor for Amazon QuickSight targeted on visualization and entrance finish experiences. He’s captivated with BI, knowledge visualization and low-code/no-code experiences. Previous to QuickSight he was the lead product supervisor for Inforiver, answerable for constructing a enterprise BI product from floor up. Bhupinder began his profession in presales, adopted by a small gig in consulting after which PM for xViz, an add on visualization product.

Latest articles

Related articles

Leave a reply

Please enter your comment!
Please enter your name here