Dear all,
i have installed OBIEE 11.9 on windows.
i am trying to create a repository in bi administration tool. in my business Model layer, i have a column for Std Gender which have value 'F' for female and 'M' in the corresponding table.
now i want to create two more logical column, one for Total Female and one for Total Male based on the value.
how could i do that?

Thank you.