# \#pivot-table **URL:** https://community.amazonquick.com/tag/pivot-table/193.md [Latest](https://community.amazonquick.com/latest.md) · [Categories](https://community.amazonquick.com/categories.md) · [Tags](https://community.amazonquick.com/tags.md) --- ## [How to handle semi-additive measures (account balance / snapshot) when collapsing hierarchy in a Pivot Table?](https://community.amazonquick.com/t/how-to-handle-semi-additive-measures-account-balance-snapshot-when-collapsing-hierarchy-in-a-pivot-table/53594)
**Author:** [@Robert\_Esteves](https://community.amazonquick.com/u/Robert_Esteves)\ **Replies:** 4\ **Last updated:** [October 1, 2026, 3:56pm UTC](https://community.amazonquick.com/t/how-to-handle-semi-additive-measures-account-balance-snapshot-when-collapsing-hierarchy-in-a-pivot-table/53594 "2026-10-01T15:56:21Z")
Hi everyone, I am building an account balance report in Amazon QuickSight and running into an issue handling a semi-additive measure when collapsing a pivot table hierarchy. Setup & Business Requirement Visual type: P… --- ## [Show a clear division between groups of Cells in a pivot table](https://community.amazonquick.com/t/show-a-clear-division-between-groups-of-cells-in-a-pivot-table/53377)
**Author:** [@mateoleon210](https://community.amazonquick.com/u/mateoleon210)\ **Replies:** 4\ **Last updated:** [September 14, 2026, 8:22pm UTC](https://community.amazonquick.com/t/show-a-clear-division-between-groups-of-cells-in-a-pivot-table/53377 "2026-09-14T20:22:24Z")
Please see the screenshot below. Im trying to have a gap between the values for a given item. To do this, I created an empty row with zeroes and then I used conditional formatting to hide all the values so it shows as a … --- ## [Pivot table error after applying conditional formatting to Total column](https://community.amazonquick.com/t/pivot-table-error-after-applying-conditional-formatting-to-total-column/53047)
**Author:** [@Lal\_Prasanth\_Paulraj](https://community.amazonquick.com/u/Lal_Prasanth_Paulraj)\ **Replies:** 3\ **Last updated:** [August 6, 2026, 9:01pm UTC](https://community.amazonquick.com/t/pivot-table-error-after-applying-conditional-formatting-to-total-column/53047 "2026-08-06T21:01:11Z")
I am getting the error message, “Please contact the Qlik team to resolve the issue,” as soon as I apply %Total\_Rank to the Total column in the pivot table. The conditional formatting is intended to identify the highest a… --- ## [Search in Dropdown Multiselect Filter Doesn't Filter to Selected Values](https://community.amazonquick.com/t/search-in-dropdown-multiselect-filter-doesnt-filter-to-selected-values/52712)
**Author:** [@C\_B](https://community.amazonquick.com/u/C_B)\ **Replies:** 6\ **Last updated:** [July 20, 2026, 5:43pm UTC](https://community.amazonquick.com/t/search-in-dropdown-multiselect-filter-doesnt-filter-to-selected-values/52712 "2026-07-20T17:43:32Z")
I have a multiselect dropdown control in an analysis. The user can type in a value to search, and the dropdown shows the correct relevant values. They are selected automatically, with an additional value for “Select All … --- ## [Empower readers with customizable tables and pivot tables in Amazon Quick Sight](https://community.amazonquick.com/t/empower-readers-with-customizable-tables-and-pivot-tables-in-amazon-quick-sight/50635)
**Author:** [@amazonquick](https://community.amazonquick.com/u/amazonquick)\ **Replies:** 2\ **Last updated:** [April 13, 2026, 5:35pm UTC](https://community.amazonquick.com/t/empower-readers-with-customizable-tables-and-pivot-tables-in-amazon-quick-sight/50635 "2026-04-13T17:35:07Z")
We are excited to announce the general availability of customizable tables and pivot tables in Amazon Quick Sight, the AI-powered business intelligence (BI) service. With this enhancement, readers can customize their das… --- ## [PivotTable - The totals are summing my Ratio's rather than using the Ratio Formula](https://community.amazonquick.com/t/pivottable-the-totals-are-summing-my-ratios-rather-than-using-the-ratio-formula/51618)
**Author:** [@JCookGTX](https://community.amazonquick.com/u/JCookGTX)\ **Replies:** 7\ **Last updated:** [March 24, 2026, 3:15pm UTC](https://community.amazonquick.com/t/pivottable-the-totals-are-summing-my-ratios-rather-than-using-the-ratio-formula/51618 "2026-03-24T15:15:09Z")
Ratio Issue I have a PivotTable with my Branches as Columns and “Chart Of Accounts” on my rows(Revenue, Labor, Direct Costs, etc.). My Values are my “Actual Amounts” and “Ratio” I am calculating the ratio of dollars sp… --- ## [Create a Range Filter with Min/Max Values Defaulted to Pivot Value Fields? pt 2](https://community.amazonquick.com/t/create-a-range-filter-with-min-max-values-defaulted-to-pivot-value-fields-pt-2/51648)
**Author:** [@C\_B](https://community.amazonquick.com/u/C_B)\ **Replies:** 12\ **Last updated:** [March 19, 2026, 2:25pm UTC](https://community.amazonquick.com/t/create-a-range-filter-with-min-max-values-defaulted-to-pivot-value-fields-pt-2/51648 "2026-03-19T14:25:34Z")
@JacobR Continuing the discussion from Create a Range Filter with Min/Max Values Defaulted to Pivot Value Fields?: Is there any way at all to be able to set a minimum and maximum value in a filter based on the values … --- ## [Create a Range Filter with Min/Max Values Defaulted to Pivot Value Fields?](https://community.amazonquick.com/t/create-a-range-filter-with-min-max-values-defaulted-to-pivot-value-fields/51644)
**Author:** [@C\_B](https://community.amazonquick.com/u/C_B)\ **Replies:** 1\ **Last updated:** [February 25, 2026, 10:34pm UTC](https://community.amazonquick.com/t/create-a-range-filter-with-min-max-values-defaulted-to-pivot-value-fields/51644 "2026-02-25T22:34:27Z")
How can I create a range filter (min and max) on a Pivot Table’s value field that defaults to the relevant min/max values in that field in the table? I am trying to replicate a slider control from Tableau (see below), bu… --- ## [Disable dashboard customizations](https://community.amazonquick.com/t/disable-dashboard-customizations/51294)
**Author:** [@Olek](https://community.amazonquick.com/u/Olek)\ **Replies:** 5\ **Last updated:** [February 20, 2026, 8:03am UTC](https://community.amazonquick.com/t/disable-dashboard-customizations/51294 "2026-02-20T08:03:16Z")
Hello In tables and pivots there is an option to customize visual. It can be disabled by switching off ‘Reader Customizations‘ in analysis. However when I export dashboard to JSON file, there is no place that configures… --- ## [Hide pivot by default and enable data when actions applied](https://community.amazonquick.com/t/hide-pivot-by-default-and-enable-data-when-actions-applied/51194)
**Author:** [@Lasya](https://community.amazonquick.com/u/Lasya)\ **Replies:** 5\ **Last updated:** [February 10, 2026, 6:23pm UTC](https://community.amazonquick.com/t/hide-pivot-by-default-and-enable-data-when-actions-applied/51194 "2026-02-10T18:23:15Z")
Hi, I have a requirement to apply actions on counts to raw data at ID level. But, I would like to hide the raw data by default and only show the raw data when the actions are applied on the counts in pivot on the same p… --- ## [\[Feature Request\] consolidated list of UX, Styling, and Data Management improvements](https://community.amazonquick.com/t/feature-request-consolidated-list-of-ux-styling-and-data-management-improvements/51348)
**Author:** [@chanhlm](https://community.amazonquick.com/u/chanhlm)\ **Replies:** 1\ **Last updated:** [January 30, 2026, 3:43pm UTC](https://community.amazonquick.com/t/feature-request-consolidated-list-of-ux-styling-and-data-management-improvements/51348 "2026-01-30T15:43:23Z")
Index Category Feature Request Context & Pain Points 1 Styling Granular Column Formatting (Headers, Values, Totals) Context: Currently, Conditional Formatting primarily targets cell values. We cannot style Header… --- ## [In Pivot table subtotal, I want to disable text in one column and allow text in another column](https://community.amazonquick.com/t/in-pivot-table-subtotal-i-want-to-disable-text-in-one-column-and-allow-text-in-another-column/50873)
**Author:** [@kiran.thorat](https://community.amazonquick.com/u/kiran.thorat)\ **Replies:** 3\ **Last updated:** [December 29, 2025, 8:10pm UTC](https://community.amazonquick.com/t/in-pivot-table-subtotal-i-want-to-disable-text-in-one-column-and-allow-text-in-another-column/50873 "2025-12-29T20:10:05Z")
Hi, this is a Pivot Table visual. I have enabled subtotal feature and as you can see, I have two columns Percentage and Base Respondent. Here I want to show subtotal of Base Respondent column but hide subtotal of Percent… --- ## [Pivot table performance issue](https://community.amazonquick.com/t/pivot-table-performance-issue/50869)
**Author:** [@harpar1808](https://community.amazonquick.com/u/harpar1808)\ **Replies:** 5\ **Last updated:** [December 23, 2025, 4:30pm UTC](https://community.amazonquick.com/t/pivot-table-performance-issue/50869 "2025-12-23T16:30:50Z")
Hello, I am loading data into pivot table. There are 400K rows (in the spice-d dataset) however my Pivot table just has 3 levels and simple sum (no calculated fields, any formatting etc are there). Still this takes clos… --- ## [Pivot Table Dropping Columns when Certain Dimensions Utilized](https://community.amazonquick.com/t/pivot-table-dropping-columns-when-certain-dimensions-utilized/50745)
**Author:** [@dspringer](https://community.amazonquick.com/u/dspringer)\ **Replies:** 7\ **Last updated:** [December 22, 2025, 3:47pm UTC](https://community.amazonquick.com/t/pivot-table-dropping-columns-when-certain-dimensions-utilized/50745 "2025-12-22T15:47:15Z")
Hello, I’m having some issues with a pivot table vision. I have a month-year field in columns, sales in values, and a parameter controlled selectable dimension field in group by. We bill invoices for the following busi… --- ## [How to show string in pivot table cell?](https://community.amazonquick.com/t/how-to-show-string-in-pivot-table-cell/50632)
**Author:** [@cewu](https://community.amazonquick.com/u/cewu)\ **Replies:** 3\ **Last updated:** [December 17, 2025, 4:22pm UTC](https://community.amazonquick.com/t/how-to-show-string-in-pivot-table-cell/50632 "2025-12-17T16:22:51Z")
Hi, I am trying to use pivot table to show my data. For example: my data in dataset like: I want result like: So I created last\_value calculation field using lastValue function: lastValue(value, \[{value} ASC\], … --- ## [Dynamic Header Configuration in Pivot Tables](https://community.amazonquick.com/t/dynamic-header-configuration-in-pivot-tables/50564)
**Author:** [@mirandadinis70](https://community.amazonquick.com/u/mirandadinis70)\ **Replies:** 1\ **Last updated:** [November 17, 2025, 10:33pm UTC](https://community.amazonquick.com/t/dynamic-header-configuration-in-pivot-tables/50564 "2025-11-17T22:33:02Z")
Hello, I’m building a pivot table in Amazon QuickSight where I need the column headers to update dynamically based on the user-selected Month and Year filter. Current Setup I have two calculated measures: total\_cu… --- ## [How to Repeat Row Labels in a PivotTable](https://community.amazonquick.com/t/how-to-repeat-row-labels-in-a-pivottable/50219)
**Author:** [@qihul](https://community.amazonquick.com/u/qihul)\ **Replies:** 3\ **Last updated:** [November 3, 2025, 6:59am UTC](https://community.amazonquick.com/t/how-to-repeat-row-labels-in-a-pivottable/50219 "2025-11-03T06:59:27Z")
Is it possible to have the pivot table’s row label repeated to avoid large empty space (audience have to scroll down to see the label/name The method in “https://community.amazonquick.com/t/how-to-repeat-row-labels… --- ## [Filter pivot table with periodOverPeriodPercentDifference value for last date](https://community.amazonquick.com/t/filter-pivot-table-with-periodoverperiodpercentdifference-value-for-last-date/49796)
**Author:** [@Valentin](https://community.amazonquick.com/u/Valentin)\ **Replies:** 5\ **Last updated:** [October 16, 2025, 8:21am UTC](https://community.amazonquick.com/t/filter-pivot-table-with-periodoverperiodpercentdifference-value-for-last-date/49796 "2025-10-16T08:21:01Z")
Hi! I’m struggling with filtering pivot table by last periodOverPeriodPercentDifference value. I have a table like this In my scenario all amount values are actually created with calculated field like this sumOver… --- ## [Pivot Table Doesn't show all columns in dataset until rows loaded by scrolling](https://community.amazonquick.com/t/pivot-table-doesnt-show-all-columns-in-dataset-until-rows-loaded-by-scrolling/49828)
**Author:** [@TheCardlessMoose](https://community.amazonquick.com/u/TheCardlessMoose)\ **Replies:** 5\ **Last updated:** [October 13, 2025, 2:15pm UTC](https://community.amazonquick.com/t/pivot-table-doesnt-show-all-columns-in-dataset-until-rows-loaded-by-scrolling/49828 "2025-10-13T14:15:45Z")
We have had users complaining about a behavior of the Quick Sight pivot tables observed in our production dashboards. The dataset in question is related to customer payments and is a SPICE dataset. Records essentially … --- ## [Dynamic Column Headers in Pivot Table based on Selected Year Parameter](https://community.amazonquick.com/t/dynamic-column-headers-in-pivot-table-based-on-selected-year-parameter/49552)
**Author:** [@vishalbagad](https://community.amazonquick.com/u/vishalbagad)\ **Replies:** 7\ **Last updated:** [September 18, 2025, 8:49pm UTC](https://community.amazonquick.com/t/dynamic-column-headers-in-pivot-table-based-on-selected-year-parameter/49552 "2025-09-18T20:49:13Z")
Hello Community, I am working on a requirement where I created a parameter called SelectedYear with values like 2015, 2016, … 2025, etc. Currently, I am showing Sales, GP, and GP% in a Pivot Table with the below format… --- ## [Pivot Table内の\[Percent of Total (全体比)\] 関数を使わずにPercent of Totalを集計したい](https://community.amazonquick.com/t/pivot-table-percent-of-total-percent-of-total/49704)
**Author:** [@higuyuta](https://community.amazonquick.com/u/higuyuta)\ **Replies:** 4\ **Last updated:** [September 17, 2025, 4:23am UTC](https://community.amazonquick.com/t/pivot-table-percent-of-total-percent-of-total/49704 "2025-09-17T04:23:32Z")
Pivot Tableを使って以下のような表を作成しています。現在は\[Percent of Total\]を適用させて％を出していますが、当然これは{process\_test}のaやbをフィルターで除外してしまったら、それに応じて％も変わってしましますが、これをフィルターをかけても％が変わらないようにしたいです。 また、例えばこの％の数値をVertical bar chartにして、aのプロセスでもっとも％が高いcountry\_test… --- ## [Pivot Table missing combinations](https://community.amazonquick.com/t/pivot-table-missing-combinations/49459)
**Author:** [@Francesca](https://community.amazonquick.com/u/Francesca)\ **Replies:** 3\ **Last updated:** [September 11, 2025, 5:06pm UTC](https://community.amazonquick.com/t/pivot-table-missing-combinations/49459 "2025-09-11T17:06:29Z")
Hello, I have a pivot table with no filters, year in columns and several fields in rows (9). This is the output I get when I display it: 2 problems there: Totals do not match: it looks like some values that should… --- ## [Redirect from pivot table to another analysis with filter applied](https://community.amazonquick.com/t/redirect-from-pivot-table-to-another-analysis-with-filter-applied/48828)
**Author:** [@uripablo](https://community.amazonquick.com/u/uripablo)\ **Replies:** 5\ **Last updated:** [September 10, 2025, 12:50pm UTC](https://community.amazonquick.com/t/redirect-from-pivot-table-to-another-analysis-with-filter-applied/48828 "2025-09-10T12:50:52Z")
Hi everyone, I’m working with a pivot table in Amazon Quick Sight and wondering if the following is possible: Is there a way to make a cell in the pivot table clickable, such that when a user clicks on a product (or an… --- ## [Pivot table % totals issue](https://community.amazonquick.com/t/pivot-table-totals-issue/47038)
**Author:** [@JRoz](https://community.amazonquick.com/u/JRoz)\ **Replies:** 4\ **Last updated:** [September 6, 2025, 3:19pm UTC](https://community.amazonquick.com/t/pivot-table-totals-issue/47038 "2025-09-06T15:19:44Z")
Hi everyone, We’re running into a recurring issue with user expectations around percentage totals in pivot tables, and I’m wondering if anyone has tips or workarounds to improve clarity. We’re using a pivot table with … --- ## [Pixel Perfect Repeating Sections Show “No Data” in Analysis View, Break PDF Export](https://community.amazonquick.com/t/pixel-perfect-repeating-sections-show-no-data-in-analysis-view-break-pdf-export/48901)
**Author:** [@Dave\_LeBlanc](https://community.amazonquick.com/u/Dave_LeBlanc)\ **Replies:** 3\ **Last updated:** [August 27, 2025, 5:11pm UTC](https://community.amazonquick.com/t/pixel-perfect-repeating-sections-show-no-data-in-analysis-view-break-pdf-export/48901 "2025-08-27T17:11:02Z")
I’m encountering a potential bug in Quick Sight Pixel Perfect reports involving repeating sections. Visuals configured inside repeating sections return “No Data” in the Analysis view The same visuals display data corre… --- ## [Displaying “0” in Pivot table instead of blanks](https://community.amazonquick.com/t/displaying-0-in-pivot-table-instead-of-blanks/22499)
**Author:** [@jessarin814](https://community.amazonquick.com/u/jessarin814)\ **Replies:** 2\ **Last updated:** [August 26, 2025, 5:24pm UTC](https://community.amazonquick.com/t/displaying-0-in-pivot-table-instead-of-blanks/22499 "2025-08-26T17:24:45Z")
Hi. I know this has been requested many times, but is there now a way to display 0 instead of blanks or ‘No Data’ in a pivot table or KPI? coalesce(sum(users), 0) and replacing ‘null’ values with 0 do not solve the iss… --- ## [Pivot Tables Not Working w/ Snowflake & Direct Query](https://community.amazonquick.com/t/pivot-tables-not-working-w-snowflake-direct-query/48427)
**Author:** [@bdockstader-roi](https://community.amazonquick.com/u/bdockstader-roi)\ **Replies:** 10\ **Last updated:** [August 25, 2025, 3:37pm UTC](https://community.amazonquick.com/t/pivot-tables-not-working-w-snowflake-direct-query/48427 "2025-08-25T15:37:11Z")
I’m having an issue where whenever I try to use a pivot table visual it shows a “No Data / There was no data found for the visual” error, even though I know there’s data there. This happens only when I’m using direct que… --- ## [Getting previous row dynamically-calculated field value in current row](https://community.amazonquick.com/t/getting-previous-row-dynamically-calculated-field-value-in-current-row/49399)
**Author:** [@Murali\_Kembhavi](https://community.amazonquick.com/u/Murali_Kembhavi)\ **Replies:** 2\ **Last updated:** [August 22, 2025, 7:38pm UTC](https://community.amazonquick.com/t/getting-previous-row-dynamically-calculated-field-value-in-current-row/49399 "2025-08-22T19:38:55Z")
Hi all, I’m trying to fetch the previous row calculation (this is a separate calculated field which totals all the column values) dynamically in the current row so that balance can be brought forward for next months. Pl… --- ## [Pivot table Aggregation](https://community.amazonquick.com/t/pivot-table-aggregation/49200)
**Author:** [@liya101](https://community.amazonquick.com/u/liya101)\ **Replies:** 1\ **Last updated:** [August 19, 2025, 3:27pm UTC](https://community.amazonquick.com/t/pivot-table-aggregation/49200 "2025-08-19T15:27:49Z")
Hi , I got 2 aggregate levels in my data. One is the parent level and then we have the child level. For example in my case, Parent : Dormant is the parent Child: Dormant 35 percent and Dormant 45 percent Dormant is … --- ## [Pivot table loses columns](https://community.amazonquick.com/t/pivot-table-loses-columns/48577)
**Author:** [@Jeremy\_Likezero](https://community.amazonquick.com/u/Jeremy_Likezero)\ **Replies:** 7\ **Last updated:** [August 5, 2025, 2:57pm UTC](https://community.amazonquick.com/t/pivot-table-loses-columns/48577 "2025-08-05T14:57:01Z")
This pivot table is displaying 5 category columns in the QS GUI: There are actually 7 columns, which can be seen when you download to Excel: The “Role” field is a calculated field which helps me to sort the columns… [Next page](https://community.amazonquick.com/tag/pivot-table/193.md?match_all_tags=true&page=1&tags%5B%5D=pivot-table)