I am calculating freight cost (which is on header level) for orders and would like to show all orders along with order items in an OLAP table.
Now there are certain order items which I would like to identify and be ignored for which I created a KPI called "identifier":
Now when Identifier is 1, I want POSNR of such order items to be considered and take the first available "POSNR" and put the Freight cost against it.
The result however is coming on the first POSNR which should have been overlooked based on my identifier: