Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to remove empty sub rows from a particular column in the OTBI report? — Cloud Customer Connect
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

How to remove empty sub rows from a particular column in the OTBI report?

Received Response
22
Views
2
Comments

Summary:

I am getting the sub rows for employee self-rating and manager rating. I want to fetch the ratings for sections goals, competencies and overall summary.

I have applied the filters for all. For example, for Employee Self-rating goals : FILTER("Workforce Performance - Performance Rating Real Time"."- Performance Rating"."Average Calculated Worker Section Rating" USING ("Workforce Performance - Performance Rating Real Time"."- Performance Document Section"."Document Section Definition" = 'Performance Goals'))

and like this only I have applied filters for all other rating columns.

PFA, I am attaching the screenshot in which I have highlighted those sub-rows that I don't want.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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