Payroll - Element Entries History Real Time - Input Value

Summary

Payroll - Element Entries History Real Time - Input Value

Content

Hi,

I am trying to create an analysis for the subject area Payroll - Element Entries History Real Time and I am struggling to get the input value in Columns rather than in rows.

As Example my current analysis giving the output as below -

Person Number	Element Name	Input Value Name	Displayed Input Value
12345	Salary	Amount	100
12345	Salary	Test1	Y

 

But I want the output like below -

Person Number	Element Name	Amount	Test1
12345	Salary	100	Y

 

Can you please let me know is there any option to change the table view to get the expected output.