Skip to Content
0
May 11, 2009 at 09:21 AM

hierarchy in CR2008

10 Views

Hi all,

i am newbie in BW and CR. I am creating a report in CR from a query and i have this problem. Infoobject sales manager has hierarchy which is like this:

-Region

-City

-Sales Manager

When i create report in CR how can i make such a hierarchy ??? When i choose sales manager into the report i get the same data multiple times. The report looks like this:

Region - data

Region - data

Region - data

Region - data

....

...

...

CityA - data

CityA - data

CityB - data

....

....

....

.....

Sales managerA - data

Sales managerA - data

Sales managerB - data

...

....

....

And i want that the report looks like this:

Region

CityA

Sales Manager - data

Sales Manager - data

CityB

Sales Manager - data

Sales Manager - data

What should i do??? I hope my explanation isnt confusing :-D

Edited by: Martin Zluky on May 11, 2009 1:17 PM