Hiding of rows in pivot table view

3024008

Hi,

I want to hide the rows in a pivot table view based on a conditon. for ex:

i have a pivot view with following structure

 

Op Code	Voyage	op cost	running cost	total
v	10	1001	100	1101
	20	0	0	0
	30	100	100	200

Now i need to hide the row which has total 0.. the measure are coming from same column but not calculated in OBIEE.

Regards

Sreekanth

jprakash

Sreekanth,

You can achieve using selection step.

• Right-click a row at left most column (Op Code in ur case)
• From the context menu choose the column name( Op Code) -> Remove -> Based on Custom Codition. In my case the column name is "Per Name Month"

• Choose the condition for total "0"

Thats it. You are done!

Thanks, JP