Display a hierarchy followed by a table in Webi

[Former Member]

Hello Experts, I have a report which is to be displayed as the following:

There is a hierarchy that expands down to a table.

+ Géographie

+ France

+ Lyon

StoreName Items QuantityInStock QuantitySold

Store A Shoes 10 5

Store B Bags 15 100

+ Paris

StoreName Items QuantityInStock QuantitySold

Store C Jeans 20 105

Store D Tops 25 200

I am using a vertical table with

1st column - Hiérarchy Géographie

2nd Column - StoreName

3rd Column - Items and so on....

As you can see above, i want the Detail table to be displayed only at the lowest hierarchy. But when i tried the above, i am having the table repeated at every level of the hierarchy

Could you please suggest best practice or a better way to do the above.

Thanks in advance

Best Regards

[Former Member · Accepted solution]

Hi Naila,

There is a blog in SCN similar to your requirement. please follow the below link it may be helpful.

https://blogs.sap.com/2013/06/05/bobj-trick-to-display-table-data-in-hierarchy-format/

Regards

Venkatesh