How can I filter on column and not a measures in OTBI
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'))