shaylaFrequent Visitor2 years agoSolvedLowest/ Highest value Hi All, Instead having the lowest discount in the whole column, I would like to have the lowest discount % in the year as well. how anyone help with it? Thanks! Show MoreDangar332 to shayla2 years agoHI, shayla try belowcalculate( min(table[discount%]), table[year] = max(table[year]) )
Dangar332 to shayla2 years agoHI, shayla try belowcalculate( min(table[discount%]), table[year] = max(table[year]) )
Dangar332 to shayla2 years agoHI, shayla try belowcalculate( min(table[discount%]), table[year] = max(table[year]) )
shaylaFrequent Visitor2 years agoThanks for reply! @Dangar33 when I put the formular below, it only gives the max discount% in 2023, but I need max/min for every year.. could you please rectify my formula? Thanks!
Dangar332Resident Rockstar to shayla2 years agoHI, shayla try belowcalculate( min(table[discount%]), table[year] = max(table[year]) )
Related content2nd Highest ValueExclude Lowest and Highest ValuesColor only highest and lowest valuesgetting lowest value and highest valueFind Highest Value of a Column
