Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I think the syntax is slightly off. Try this: INDEXCOL(CASE WHEN genre = 'H' THEN 0 WHEN genre = 'F' THEN 1 ELSE 2 END , "Homme"."Femme"."NR") See here for more info. https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-indexcol