Forum Discussion

codfail's avatar
codfail
Frequent Visitor
9 years ago

Dynamic Column Headers

Hello all,

I have a question regarding column name changes. I am trying to build a report that will give quarterly data and would like the month names in the matrix column headers to change accordingly. 

For example:
       when Q1 then mnth1=Jan, mnth2 = Feb, mnth3 = March
       when Q3 then mnth1= Jul, mnth2 = Aug, mnth3 = Sep

 

 

 

Has anyone ran into this before or have an idea on how to do it?

 Thank you for the help in advance!

2 Replies

    • codfail's avatar
      codfail
      Frequent Visitor
      8 years ago

      Hello Eric_Zhang,

      Sorry for the late response (needed admin's permission), but it didn't work for me. Your example seems to do what I wanted, so it may be due to the way my data is set up and I may just need to change a couple things. Thank you for your help!