I have the ffg chart:
I am trying to normalize this graph between 0 and 1.
I just need to get the maximum and minimum for each line and then I can normalize it but I can't seem to get this because my expression,
Value/Value1 which is actually equal to max(Value)/max(Value1), but I do not want this,
I want Value/Value1 and also get the MAX(Value) throughout the years. so I can eventually use an expression like the ffg:
(Value/MAX(Value))/(Value1/MAX(Value1)) --> results in 1 all the time which I do not want
PLEASE HELP, this is really important for me to implement.