OBIEE Pivot Table custom Grouping Values

Question

Hi,

I have a special case,

I have a Product Dimension and values are as below, i am struggling to arrange Product Name according to my Requirements. I try to Use CASE Statements which is working fine For Table View but It is not Arranging Product Names for Pivot table  can you please help on this,

Current Product Pivot Table

Product NameAmountKeyboard120Mouse80Chair970Tables2100Window Glass1800

Want to Achieve: in Pivot table

NameAmountKeyboard120Mouse80Total (key,mouse)200Window Glass500Tables1000Chair1500Total3000

Sher Ullah Baig · Answer

Hi Srini,

Thanks, i tired this but problem is Sorting on Pivot table you can sort ASC or DESC but i want to arrange according to my needs for Product Name

Want to Achieve: in Pivot table

NameAmountKeyboard120Mouse80Total (key,mouse)200Window Glass500Tables1000Chair1500Total3000

SriniVEERAVALLI · Answer

@ Christian You allways there for us to correct us,  thank you.

My wording is wrong Group i mean

case when "Time"."Year"<2005 then 'Year <2005' else 'Year>=2005' end

this would show up as

[Deleted User] · Answer

Time for some Jeopardy: What are "Groups and Calculacted Items" in OBIEE? ==> http://docs.oracle.com/middleware/1221/biee/BIEUG/filter.htm#BIEUG1033