Column names in the format "start week date - end week date"

[duncan]

Hello @Amit_Raj , welcome to the Quicksight community!

You may be able to use a calculated field similar to the second calculation described in the solution of this post:

How to add dynamic header for a table

Hi team, I have a use case where I need to have dynamic headers in a table. Specifically, I need the last 5 weeks to automatically get updated with the new week as time progresses. For example, I need to have the last 5 weeks displayed in the columns, along with their corresponding week numbers. I know that this is possible to do using parameters, but I’m finding it challenging to implement based on the documentation. Could you please provide some guidance or suggestions on how I can achieve …

Where you use your original calculated field to determine the dates and then concat them.

Concat - Amazon QuickSight