# Dynamic column names

**URL:** <https://community.amazonquick.com/t/dynamic-column-names/5347>\
**Category:** Q&A\
**Tags:** parameters, quick-sight\
**Created:** [August 11, 2022, 10:50am UTC](https://community.amazonquick.com/t/dynamic-column-names/5347 "2022-08-11T10:50:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jelena](https://avatars.discourse-cdn.com/v4/letter/j/f19dbf/32.png) [@Jelena](https://community.amazonquick.com/u/Jelena)\
**Post date:** [August 11, 2022, 10:50am UTC](https://community.amazonquick.com/t/dynamic-column-names/5347/1 "2022-08-11T10:50:38Z")

</div>

Hi Community,

Is it possible to have dynamic column names in the table based on the value from Date filter (year from the date) ?  
For example, when the user picks date 11-08-2022 the column names should be:  
Column 2022, Column 2023, Column 2024, Column 2025 and Column 2026.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/c/c859e10b8c7537b839914d79d8302251e648371c.png)

---

<div class="post-metadata">

**Author:** ![Neeraj](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/neeraj/32/15309_2.png) [@Neeraj](https://community.amazonquick.com/u/Neeraj)\
**Post date:** [August 25, 2022, 5:17pm UTC](https://community.amazonquick.com/t/dynamic-column-names/5347/2 "2022-08-25T17:17:05Z")

</div>

Hi Jelena ,  
Based on you what you explained here , you can create a calculated field such as  
Column - Year = concat('Column ’ , toString(Year))

And what you select on data , values can be passed through parameter and filter for last 3 years ( in this example I have sales data for 2021 and 2018 and showing last 3 years in table)  
Your column on pivot table can be rendered dynamically based on year in selected date.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/39738b78a6dd63731fbfa61c1d5b725768ed194f.png)

- pDate is parameter used

This is how it would be achieved , Hope this helps your use-case

![Use-case1 (2)](https://d1wl4jav5dp96l.cloudfront.net/original/2X/a/a2ec28858bf353e7e5312a66b9279731e82230ff.gif)

---

<div class="post-metadata">

**Author:** ![imbipul](https://avatars.discourse-cdn.com/v4/letter/i/2acd7d/32.png) [@imbipul](https://community.amazonquick.com/u/imbipul)\
**Post date:** [December 21, 2022, 9:21am UTC](https://community.amazonquick.com/t/dynamic-column-names/5347/3 "2022-12-21T09:21:23Z")

</div>

Hi @Neeraj,  
I have the same use case of having dynamic column name in pivot table.  
I cannot follow your solution clearly.

Let me brief of my use case.  
Based on the Region selected the column name of a column should change.  
eg, if region = “NA” then column name = “CSI Sec” else if region = “EU” then the same column name should change to “CSI Div”.

What should be the solution for given usecase?

---

<div class="post-metadata">

**Author:** ![iamtarun](https://avatars.discourse-cdn.com/v4/letter/i/82dd89/32.png) [@iamtarun](https://community.amazonquick.com/u/iamtarun)\
**Post date:** [November 16, 2023, 4:11pm UTC](https://community.amazonquick.com/t/dynamic-column-names/5347/4 "2023-11-16T16:11:40Z")

</div>

Hi @imbipul, Have you found any solution for your use case. I have a similar issue.

---

<div class="post-metadata">

**Author:** ![hcorbett](https://avatars.discourse-cdn.com/v4/letter/h/b782af/32.png) [@hcorbett](https://community.amazonquick.com/u/hcorbett)\
**Post date:** [April 1, 2025, 1:16pm UTC](https://community.amazonquick.com/t/dynamic-column-names/5347/5 "2025-04-01T13:16:51Z")

</div>

How do I tell the parameter to use the calculated field?