Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table diagram with products and sales. Of all the rows in the table, I'd like to
- show only first 20% of all SubProduct1s
- show only first 40% of all SubProduct2s
- show only first 60% of all SubProduct3s
Thus limiting the number of rows in the table.
I tried with something like
PICK
(Match(PRODUCT,'PRODUCT1','PRODUCT2','PRODUCT3'),AGGR(NODISTINCT COUNT(SUBPRODUCT),PRODUCT) * (vProzProd1 / 100)
but I nver get the desired result.
See example attached. How can I do this with the help of variables.?
Thx - Marcel
Marcel,
i think with dim limits as with set analysis it might be difficult.
But there is some solution of course.
I hope that it helps.
regards
Darek
Hi
thank you for this rank-approach. I know its possible using rank or similar, however, I wished to get the same using dynamic dimension limitation, as it seemed easier at first look.
Now, I'm having the impression that the dimension limits do not support dynamic expressions, such as
PICK(Match(PRODUCT,'PRODUCT1','PRODUCT2','PRODUCT3'),AGGR(NODISTINCT COUNT(SUBPRODUCT),PRODUCT) * (vProzProd1 / 100)
and similar. Even the simple PICK(Match(PRODUCT,'PRODUCT1','PRODUCT2','PRODUCT3'),1,2,3) does not work as dimension limit.
Regards - Marcel
Anyway i'am gald if my answer is helpful
regards
Darek