Set analysis by dimention

[Anonymous]

Hello,

I want to Calculate a set analysis that depend on the dimention, I have dimentions Indicator and Train, and we want to calculate the value by Indicator and Train for the max Year(the max year of each train).

I need something like this:

but I get (it only calculates the value for the max year, but I need the value for the max year per train):

I use the set analysis:

The data used is:

How can I solve this?

[nsetty]

Hi John

You have to use Generic Load to achieve the results.

Thanks

Nagesh

[vishsaggi · Accepted solution]

Try this in your expr:

= Firstsortedvalue(Value, -Aggr(Max(Year), Indicator, Train))

[Anonymous]

Thanks for your answer

[Anonymous]

Thanks for your answer. It will work correctly

[vishsaggi]

No Problem.