Skip to Content
0

WEBI: Fetch relative dimension corresponding to lowest measure.

Oct 12, 2017 at 11:21 AM

21

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

William Ayd Oct 12, 2017 at 11:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded