Skip to Content
0
Oct 12, 2017 at 11:21 AM

WEBI: Fetch relative dimension corresponding to lowest measure.

69 Views

Hi All,

I want to fetch the dimension value with respect to the minimum amount in a block.

That block has no dimension value as a field.

EG: Data

Plant Product Price Other columns....

P1 A 10

P1 B 20

P2 C 30

P2 D 40

Expected Result

Plant Product Price Other columns....

P1 A 10

P2 C 30

Using context I can get the Plant wise lowest Price column but not able to get the Product, It is getting me #MULTIVALUE.

Thanks in Advance.