You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Pivot Table - Value Filter

edited Jun 3, 2021 6:19PM in Reporting and Analytics for HCM 2 comments

Content

Hi, I am looking at how many assignment actions have been processed on the same effective start date per employee. In OTBI I have an assignment history report looking at events and if I export this to Excel it's very easy to create a pivot table to count the number of events that have the same effective start date. I can then apply a Value Filter on the effective date column to say where count is greater than 1. 

I'm struggling to achieve the same result using a Pivot Table view on the analysis in OTBI. 

Can anyone shed any light please?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!