Take individual fields and group them under one field.
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
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!!
Re: Take individual fields and group them under one field.
Thanks For the reply but each Sales1 is its own field not a value of a Oracle field. I want group all the individual 12 Sales fields rename them to its corresponding month and then put those fields under 1 field labeled Month