set analysis to bring one record

[renjithpl]

Hi All,

I have one account number which has 3 currencies (AUD, NZD and USD), the numbers are converted in AUD.

In my straight table, the currency column showing blank, because it has three currencies..

the only possible option i have is the account number belongs to country "Australia".

I want to show the currency "AUD" instead of blank.

Any idea to bring in this output.

May be some set analysis also will help.

somthing like this

=only({<Country = {$(=max(Country))}>}Currency)

Cheers

Ren

[schlettig]

you could add another table to the data model for looking up Country to Currency:

load

          Country,

          Currency as Default_Curreny

..

that's linked via the country field in you Account Data.

Than you could simply use Default_Currency to be shown.

BR,

Christian

[PrashantSangle]

Hi,

Create Inline Table and Mention Currency and CountryName in that,

Try something like this,

LOAD * INLINE [

Country,Currency

Australia,AUD

];

Regards

[jonathandienst]

Hi

Its not possible to use a set expression like that. The set expression is evaluated once for the whole chart, and not on a row-by-row basis.

I suggest that you post a sample of your model, so that people can make informed suggestions, rather than guessing.

HTH

Jonathan