But if I change the Levels of my Dimensions, the values become duplicates as you can see in the picture. Usually, the dimension "Länder" (=Country) comes first, after that "Artikelnr."(=Article groups) then the order you can see in the picture.
This is the order I wrote in the formula of each Dimension either. But to get different impressions of the Data, the user will change the order of them. Which makes it impossible to sort the Values in this way. Does anyone have an idea how to make it more flexible?
The Problem is, if I would put Dimension 3 (=Customer) on the first place, the customer would appear for each Product Group he purchased a Product of. I think this is because of the structure I built on the last part of my formula (underlined).