I have trouble to arrange number in order. Here is the code
Sort(
Distinct(
Filter(
Mastercopy_1,
SYSTEM = Dropdown1.Selected.Result,
'Sub System'= Dropdown4.Selected.Result,
'EQUIPMENT TYPE'= Dropdown5.Selected.Result,
COMPONENT= Dropdown6.Selected.Result
),
'OPERATING TEMP (°C)'
),
Result,Ascending
)
and this is the result
