Help with dates from JD Edwards

[shalensookdeo]

Good Day

Please can I kindly seek some ideas to get my months a selectable format. They are currently vertical and named as Net Posting 01 etc etc.

How can i change them that i can actually select them and not the date within the columns?

Thanks

[jonathandienst]

I expect that each month here is an expression in a straight table.

To make the months selectable, you will need to create the field in the load script and then change the table to a pivot, add the field as a dimension, edit the expression to remove the month selection and then pivot the months to the top ot make a cross table. Now if you select a month or months, the table will collapse to display only the selected month(s)

[shalensookdeo]

Thank you

would you know how i can link this table to it? I think this may work.

[dplr-rn]

Did you try crosstable? that way Net Posting 01, Net Posting 02 becomes column values and you can link to above table

[dplr-rn]

Any luck?