Display of hierarchy

[Former Member]

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.

[Former Member]

In order to have got other datas at the bottom of the hierarchy, go to the query property/data format/multidimensionnal view/display and open lines in hierarchy bis "0orgunit"