2 Replies Latest reply on Jun 17, 2013 10:14 AM by User521140-OC

# Hide rows in Pivot table Calculated Items in OBIEE 11g

Hi All,

I have requirement to show values in Pivot table such that values are divided into two sub totals and also shown in Grand Total.

For Sub Total 1, all the rows can be shown with Sub total value. But for Sub Total 2, only Total value is to be shown but not all the rows. How this requirement can be done?

I tried to hide the rows in Sub total 2, but its effecting entire table so those rows are removing from Sub total 1 aswell which should not happen.

Have look in below table for more clarity. My output should be as shown in Table 2 not as in Table 1.

Table 1:

 Q1 Q2 Q3 Q4 Geography Type Asia T1 100 200 300 400 America T2 110 210 310 410 Europe T1 120 220 320 420 SubTotal1 330 630 930 1230 Asia T1 10 20 30 40 America T2 15 25 35 45 Europe T1 20 30 40 50 SubTotal2 45 75 105 135 Grand Total 375 705 1035 1365

Table 2:

 Q1 Q2 Q3 Q4 Geography Type Asia T1 100 200 300 400 America T2 110 210 310 410 Europe T1 120 220 320 420 SubTotal1 330 630 930 1230 SubTotal2 45 75 105 135 Grand Total 375 705 1035 1365

Any ideas how this can be done??

Thanks for your time.

• ###### 1. Re: Hide rows in Pivot table Calculated Items in OBIEE 11g

can u define what this subtotal 1,subtotal 2 here..

try with calculated items

for example cacluated item one Sub1=Asia+Europe

caclated item two sub2=Asia+Europe+America and as usual put row level grand total to get Total

• ###### 2. Re: Hide rows in Pivot table Calculated Items in OBIEE 11g

Hi,

Thanks for the reply.

Here Subtotal will sums up the rows basing on other column (Dimension).

SubTotal 1 sums the rows basing on the another dimension( value A and value B). SubTotal 2 sums the rows basing on aother values(values C and values C.

I understand the above solution, but that is not enough to my requirement as I need to show Regions for Subtotal 1, but not for Subtotal 2. And these Subtotals are based on another column (other than Regions).

Hope this is clear now.