Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have next problem
If there are gaps (in words) in the measurement , button works incorrect.
I don't see "product 6 " in filter , but it must be here
='('& Concat(DISTINCT {<Product = {"=Rank(Sum(volumn),4)<=4"}>} Product, ' | ') &')'
Try this
='("'& Concat(DISTINCT {<Product = {"=Rank(Sum(volumn),4)<=4"}>} Product, '"|"') &'")'
Hi,
why don't you get rid of the space in the Product field? You can do that with the trim function while loading the product.
trim(Product)
Or do you really wish to present two different products named Product6 and Product 6?
Try this
='("'& Concat(DISTINCT {<Product = {"=Rank(Sum(volumn),4)<=4"}>} Product, '"|"') &'")'