Hi everyone! I’m new to Quicksight and wanted to know how I can create the a dynamic pivot table where the value field can be adjusted dynamically using a drop down menu selection. For some details, I have a pivot table with the company name and company ID in the rows. The column consists of the mon…

Welcome @rohit_SB check out the demo central there is sample for your case. Not pivot table but logic will be the same. https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures BR

Hi @rohit_SB , We hope the reply from @ErikG worked for you. If it helped, please help the community by marking the reply as “Solution”, but let us know if this is not resolved. Thanks for posting your question on the Quick Sight Community Q&A Forum. Andrew

Hi, I followed the demoncentral example, I want to build a dropdown list instead of radio box. I have 4 dimensions in the dropdown: Year, Month, Manager and Language. Then I create calculated filed like below, but I got ifelse() syntax error. ifelse( ${pDimension} = “Year”, {year_id}, ${pDimensi…

Hello @Shou-Li_Hsu ! The original topic in this thread has been solved, but I want to make sure that your question is prioritized by the community experts. Could you please re-post your question as a new topic at the top of the community so that it will be a priority for the experts? You can link …

HI @Shou-Li_Hsu , the issue you’re facing is due to the nature of the ifelse function. Ideally, your ifelse function would have n number of if statements, followed by an else statement at the end. So i see you’ve already created your parameter, which is step 1. Step 2 would be creating a control fo…

Thank you for kindly reply. With various tries and researches, I managed to figure it out. It turns out that all return value should be the same data type. In my case, year_id and month_id are numbers, but manager and cust_language are strings. I convert year_id and month_id to string, then it work…

Creating a dynamic pivot table where the value field can be controlled with a dropdown

Q&A

rohit_SB December 20, 2023, 2:48am 4

Thank you @ErikG @abacon . I think this makes sense. Sorry I haven’t had the opportunity to touch base with this project in the last few days but the solution Erik posted makes sense logically.

Dynamic table or chart

Topic		Replies	Views
Dynamic selection of dimensions in pivot table Q&A charts , analysis , formatting , quick-sight , calculations	18	5238	January 28, 2025
Allow for dynamic Selection of Columns in a pivot table based on user selection Q&A quick-sight , pivot-table , Business-Intelligence-Engineer	5	409	January 22, 2024
Dynamic parameters based on data field Q&A parameters , quick-sight , calculations , Business-Intelligence-Engineer	4	1357	December 5, 2023
Create a filter to choose the values/metrics fields in a pivot table Q&A filters , personalization , formatting , quick-sight	1	2425	July 16, 2022
Dynamic table or chart Q&A quick-sight , Business-Intelligence-Engineer	3	38	October 16, 2025

Creating a dynamic pivot table where the value field can be controlled with a dropdown

Related topics