R12.1.3 - FSG Report - Splitting data in Col1 into different columns
Hi,
We're using R12.1.3 - we have a Report set up in GL whose output when viewed in Excel looks like this:
The quick question is:
Is there any way for the output to change, so that those values in Column A (110 0000 110000) which are Legal Entity, Cost Centre and Account, are split into separate columns of their own?
The associated setup for the report is detailed below.
Report definition:
This is the Row Set:
Define Rows:
Click into the "Low" field to see:
Row Order:
Column Set
Go to Define Columns - these contain the different Column Names, which are: