How can I filter on column and not a measures in OTBI — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How can I filter on column and not a measures in OTBI

edited Jan 26, 2021 3:50PM in Reporting and Analytics for HCM 2 comments

Summary

Filter in a sample column and not a measures how can i do it??????

Content

Hello,

I want to transform a simple column in otbi into a measures to create a filter :

I want to create a column to display the pedagogical cost as colum and not a row field, I wan to have one line per offering with column for pedagogical cost and another colum for logical cost :

 so i create a filter column like this :

FILTER (case when ("Learning Record Measures"."Learner Count" )> 1 then 
("Cost Details"."Cost Details Line Amount" )  end )

 USING ("Cost Details"."Cost Details Line Type" = 'Coût logistique'))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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