Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

SA- Payroll Element Entries Real Time - Filtering Displayed Input Value using Input Value name

Received Response
1
Views
1
Comments

Hello all,

Trying to create an allowance report using the SA - Payroll Element Entries Real Time, I have this so far

image.png

I would like to remove the 'Input Value Name' column, rename the 1st 'Displayed Input Value' as 'Allowance Justification' and the 2nd 'Displayed Input Value' column to 'Monthly Amount' - so all data is returned on one row.

To look like this

image.png

How do I say for 1st 'Displayed input Value' column where 'Input Value Name' = 'Allowance Justification' and for 2nd 'Displayed input Value' column where 'Input Value Name' = 'Monthly Amount' ?

Thanks in advance,

Ian

Tagged:

Answers