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

Question

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.

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

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD · Answer

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.

Please help me,

A.kavya.

user8618679 · Answer

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