I am trying to sum corresponding values in column "credit" against top 5 values in column "Revenue" using this array formula:
{=SUM(IF(LARGE(Sales[Revenue],{1,2,3,4,5}),1,0)*Sales[Credit])}
But it is giving sumproduct of all the values !

Please correct this formula or suggest any other solution.