Skip to Content
avatar image
Former Member

WEBI: Fetch relative dimension corresponding to lowest measure.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 12, 2017 at 11:44 AM

    Any chance your database supports database ranking? If so using that at the query level would be preferable to any report level calculations

    Add comment
    10|10000 characters needed characters exceeded