Greetings!
I would like to create a drill-down dimension where, at the lowest level, I need to hide or exclude certain dimension values. The rule is that if the number of rows associated with a dimension value does not reach X, it should not be displayed. I provide an example in the attachment.
However, hiding should only be true when we are at the lowest level. At higher levels, dimensions with such cases that we exclude should still be displayed. Therefore, the total numbers should not change.
Please send me suggestions and alternative solutions.
Thanks!
Best regards, Zoltan