OBIEE Pivot Table custom Grouping Values

Sher Ullah Baig

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 Name	Amount
Keyboard	120
Mouse	80
Chair	970
Tables	2100
Window Glass	1800

Want to Achieve: in Pivot table

Name	Amount
Keyboard	120
Mouse	80
Total (key,mouse)	200
Window Glass	500
Tables	1000
Chair	1500
Total	3000

SriniVEERAVALLI

Pull another ProductName column and use case statement for grouping required products.

In the product hide this and set aggregation ie. sigma

[Deleted User]

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

SriniVEERAVALLI

@ 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

Sher Ullah Baig

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

Name	Amount
Keyboard	120
Mouse	80
Total (key,mouse)	200
Window Glass	500
Tables	1000
Chair	1500
Total	3000