Skip to Content
0

Webi Report

Jun 15, 2017 at 05:57 PM

134

avatar image

pers-ref.txt

sap-query.xml

Hi

I need to display data in my report in a particular way and I cannot work out how to do it. I have attached an example of the data.

Where the change reason is Internal Recruitment there is an Occupancy End Date, this represents the job that the person vacated I need to show the Grade that is associated with this. I also need to show the Grade of the job that they moved into, which is always the next day after the Occupancy End Date. It shows as Occupancy Start Date. How do I go about showing the name of the Position and Grade they moved out of and the Position and Grade they moved into.

By the way my report will list many different employees so I need this to work by employee.

Many thanks

Will

sap-query.xml (5.7 kB)
pers-ref.txt (607 B)
10 |10000 characters needed characters left characters exceeded

Hi,

Bring the below objects into the Query Panel and refresh the report.

Pers Ref
Occ Start
Occ End
Position
Change Reason
Grade
Employee ID and Name

Once you have initial view, create a formula to display Employee within Grade and Position.

=[Employee ID] IN ([Grade];[Position])

This should give you an answer to most of your analysis.

Post sample data and how you want to view it, that should help others to share their ideas.

Thanks,

Jothi

0

Hi Jothi

thank you for responding to my question. I have provided a sample of the data in my original post if you would like to take a look and see if that helps with developing a solution.

Will

0

I have provided a data sample to assist with developing a solution to my problem.

5wy1j.png (161.7 kB)
0

Hi,

Use Rank function and apply filter to show or create another variable using Rank formula.

=Rank([Start Date];Top;[Test]) and Min/Max function to get 2nd requirement

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers