Skip to Content
0
Former Member
Jun 26, 2007 at 04:16 PM

Display of hierarchy

18 Views

Hello BExers... !

I'm using BI 7.0.

I'm trying to create a report with a hierarchy 0ORGUNIT ("organizational unit").

I want that this hierarchy would be the first row, and i want to put another caracteristic in the second row : "operation id".

But for the display, i want that the values of the second row id operation only appear at the bottom of the hierarchy.

Today i've got :

- orgunit operation1 key figure:3

operation2 5

operation3 7

-sales_resp1 operation1 3

operation2 4

-sales_resp2 operation2 1

operation3 7

I want to have :

- orgunit key figure :15

-sales_resp1 operation1 3

operation2 4

-sales_resp2 operation2 1

operation3 7

And when i close all hierarchy :

- orgunit "nothing" key figure : 15

could you help to me???

thanks,

Vince.