show if (front end)

[#1]

Dears,

can you help with the following problem..

Preferably I would like to solve it in the front end.

Please open the attachment for better understanding.

In the top table I have fields: Captions, Reporting ORUs and the Key field (which consists of Caption+ReportingORU - was used for joining data btw. two source files).

Now, one ReportingORU per one caption can have several values in column 'Scope'. I ranked the values in Scope 1- Significant, 2-Non-significant, 3- Not in Scope (field 'Rank').

What I would like the lower straight table to do is to show per Reporting Org only Scope which relates to lowest Rank.

So in the example in the attachment it should look:

Captions              ReportingORU                Scope                  Min(Rank)

Accounts p.          128543, 166564.....     Non-significant                 2

Many thanks for help

J.

[Miguel_Angel_Baeyens]

Hi,

I've recently answered a couple of questions in this regard (some additional info in this post among others). I'm quite sure those will work for you as well, and that should work assuming that Captions, ReportingORU and Scope are dimensions and something like this is the expression

FirstSortedValue(Scope, Rank)

Hope that helps.

Miguel

[#3]

I managed to find the solution also and used sum(aggr(min(Rank),Captions, ReportingORUs)) and also worked fine. Thanks a lot for help!

J.