Hello,
I have several months of data that I would like to rank only the first 3 months. I can rank all the months using RANKX but when I try to filter it down to just the first three months I either get an error or the entire column is 1.
The equation below is my latest attempt but it doesn't work either.
The workbook is in the link below.
RANK_3MONTHS:=RANKX(FILTER(ALLSELECTED(P_DATA),P_DATA[TIME]<=3),[SUM MEASURMENT])
https://www.dropbox.com/s/exsal4hhqealtt2/RANKX.xlsx?dl=0
Thank you in advance!
I have several months of data that I would like to rank only the first 3 months. I can rank all the months using RANKX but when I try to filter it down to just the first three months I either get an error or the entire column is 1.
The equation below is my latest attempt but it doesn't work either.
The workbook is in the link below.
RANK_3MONTHS:=RANKX(FILTER(ALLSELECTED(P_DATA),P_DATA[TIME]<=3),[SUM MEASURMENT])
https://www.dropbox.com/s/exsal4hhqealtt2/RANKX.xlsx?dl=0
Thank you in advance!
