Customizing Pivot Table in Amazon QuickSight: Hiding Columns and Adding Calculated Summaries

Question & Answer
, ,
1

I am working on a pivot table in Amazon QuickSight with the following structure:

  • Rows: created_at (Month)
  • Columns: goods
  • Values:
    • cost (sum)
    • id (count)
    • id (count (avg))
    • id (count (delta))

I have a couple of questions regarding customization:

  1. Is it possible to hide or disable specific value columns in the pivot table? For instance, I want to display only the cost (sum) column while keeping the rest hidden or available only in the total summary.
  2. Can I add calculated fields as additional value columns? Specifically, I want to include the following calculated values and display them as summaries:
  • periodOverPeriodPercentDifference(sum(cost), {created_at}, MONTH, 1)
  • periodOverPeriodDifference(sum(cost), {created_at}, YEAR, 1)
  • periodOverPeriodPercentDifference(sum(cost), {created_at}, YEAR, 1)

These calculated fields need to appear in the summary(total) section of the pivot table, or as a separate column

I would greatly appreciate any guidance or suggestions on achieving this setup.

2

Hi!

  1. Currently it is not possible to hide specific value columns while keeping them available in the total summary. Maybe you can make two versions of the table, one with and one without cost(sum)?

  2. Yes, you can add the specified calculated values by adding them as calculated fields. However, there is no support for these calculated fields to exclusively appear in the summary row. I would suggest adding another calculated field to explicitly compute summary values and display them statically.

Hope this helps!

2 Likes