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?