Skip to main content

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":

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

 

image 

The result however is coming on the first POSNR which should have been overlooked based on my identifier:

image

Hi Mrinalini,
thank you for reaching out!
To be able to help you further can you please create a support ticket?
Many thanks for your collaboration and understanding.
Best regards, Rrezarta

Reply