Showing materialnumbers together with customer hierarchy in BEX analyzer
I want to show for every customer the corresponding materials sold to this customer as a hierarchy with the customer hierarchy.
The problem is now that all materialnumbers are shown under each of the nodes where they are contained. So the materialnumbers show up twice on the lower level node and higher level node. Is there the possiblility to show the material numbers only for that hierarchy node they belong to and not twice on the upper levels?
Restrict in the query designer against material all the level 3 nodes