Can we display alpha numeric values in Pivot table?
Summary:
Can we display alpha numeric values in Pivot table?
Content (please ensure you mask any confidential information):
We have a requirement to fetch the UDT (User Defined Table) data in the OTBI analysis report. In the UDT we are capturing the EmployeeId, First Name, Last Name,..etc as column names and rows are employee number values (1234,56456..etc) and corresponding column name values capturing in the column instance value.
To achieve this requirement we are using Pivot in the OTBI analysis report. However, column instance name values are not displaying corresponding column names.
I attached sample OTBI analysis report for your reference.