Dynamic Dimension Limits do not work

[hugmarcel]

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

[#2]

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

[hugmarcel]

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

[#4]

Anyway i'am gald if my answer is helpful

regards

Darek