Two Level Hierarchies in one Pixel Perfect Report: A -> B and B -> A

[Anonymous]

Hi,

how can I realize a Report, that has two differenz hierarchies?

Levels should be:

Location (1) -> Commodity Group (2) -> PoS (3)

and

Commodity Group (1) -> Location (2) -> PoS (3)

I need two tables.

Table 1:

Location      Commodity Group      PoS                Revenue

A1g1                                                                                  12000

                        AR"a                                                           2000

                                                                    12s                  100     

Table2:

Table 1:

Commodity Group    Location      PoS                 Revenue

 AR"a                                                                                 13000

                                           A1g1                                       5000

                                                                    12s                  100     

I created the tables already and they are fine, but i can only generate one table at a time, because of hierarchy conflict.

Thanks alot!

[Ruggero_Piccoli · Accepted solution]

Hi

You need to nest the fields under the Levels node

Then you need to add the detail bands in the correct order. 

You have to repeat the process for every hierarchy of levels.

Best Regards,

Ruggero