Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to hide and suppress the bin calculated item values in obiee 11g

Received Response
21
Views
2
Comments

Hi,

i want to do custom calculations for dimentions. I have created 2 bins like A, B ..

then I want to create new calculated item C to get A-B result..

C showing A, B group  names. I want to hide group names assets, liabilities..empty data i want for C.

222.jpg

333.jpg

111.jpg

Please help me, i dont want header c group name values..

i want Header C totals only.. i dont want C groupnames..

Please help me..

How to suppress or hide the bin calculated item values?

i.e as shown in above screen shot , pls see the C values

Tahnks in advance,

A.kavya

Answers

  • user8618679
    user8618679 Rank 2 - Community Beginner

    Can you add another column and in the column formula select Column A & Column B and do a minus between them, instead of calculated item ?

    Then the third column will displays only A-B result.

    Hope it helps.

    Thanks,

    Selvi

  • Hi

    I have  tried. My report looking this

    A,B are caluculated by BIN.

    Description, USD,GBP,EUR, OTHEERS.. are different columns.

    Client required like this only as per below screen shot.

    But C = A-B.

    C showing Descrption values. I dont want C descrptions.

    How to supress/ Remove C- Decription value.

    10.jpg

    Please help me,

    A.kavya.