If don't mind only having the 'Part' pill on the view, like this...
Example of where to place your pills
Then the calculation below will meet your needs. Removing 'Types' from the view allows the data to aggregate in a way we can use to come up with the categories you want.
Size Category Calculation Image
However, if you would like to add more dimensions to the view we need to control the level of detail in our calculation. Thankfully, we can do this with LOD functions.
This calculation "fixes" out Level of Detail at the Part LOD. You can see I have added 'Another Dim' the view and it still works.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments