Limit rows in table diagram by percentage occurences of dimensions

[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.

See example attached. How can I do this with the help of variables.?

Thx - Marcel

[MK_QSL]

# Products

PICK(Match(PRODUCT,'PRODUCT1','PRODUCT2','PRODUCT3'),COUNT(PRODUCT) * vProzProd1, COUNT(PRODUCT) * vProzProd2, COUNT(PRODUCT) * vProdProz3)

Same way you can use for Sales...

What is the LOGIC in Sales Expression?

[hugmarcel]

Sorry, my example was not good enough. I have changed the request and uploaded a better example file.

Thx a lot. Marcel