Forum Discussion

Kavitha10's avatar
Kavitha10
Frequent Visitor
5 years ago

Renaming column headers in a table

Hi, I would like to know how to rename column names dynamically in my case scenario.

I have a table with column headers as CY-2,CY-1,CY,CY+1,CY+2 along with many other columns

If CY is 2020, then I need to rename the column names as

when CY is 2021, then they should get renamed as

Please, anyone has an idea ? Thanks in advance.

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Kavitha10 , Can you use the year on the column?

    Even with this year and YTD , you should be able to use year from date table

    • Kavitha10's avatar
      Kavitha10
      Frequent Visitor
      5 years ago

      Hi , thanks for your response.

      I actually have CY-2,CY-1,CY,CY+1,CY+2 as measure values (because the computations changes based on slicer selection). Is it possible to rename the measures dynamically?

      • v-xiaotang's avatar
        v-xiaotang
        Community Support
        5 years ago

        Hi Kavitha10 

         As far as I know, there's no way to rename the measures dynamically. 

        Can you add some more details? So that I might be able to find an alternative method.

         

        Best Regards,

        Community Support Team _ Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.