10 Replies Latest reply: Dec 22, 2015 10:41 AM by Neena Bhattarai RSS

    Take individual fields and group them under one field.

    Neena Bhattarai


      I have 12 individual fields I am pulling in from Oracle. They are label Sales1, Sales2, Sales3,....etc. Each field have the sales value of a month. So Sales1 is Jan. and Sales2 is Feb and so on....I want to change the name of each field to the correct month and then I want each of the months to be grouped under 1 field so it would look like this:

      Month                          This is how it looks now

      Jan                                          Sales1

      Feb                                          Sales2

      Mar                                          Sales3      

      Apr                                          Sales4

      May                                         Sales5      

      Jun                                          Sales6      

      Jul                                           Sales7               

      Aug                                         Sales8     

      Sep                                         Sales9    

      Oct                                         Sales10           

      Nov                                        Sales11            

      Dec                                        Sales12                     


      I am trying to write an expression so that the Sales of the Previous month is always displaying and I do not want to manually change the expression each time. So if there is a way to group the individual fields and rename them to a Month Field I could then write a simple expression. I am hoping there is a way to achieve this! Any help is very much appreciated!!