Forum Discussion

bvsaicharitha's avatar
bvsaicharitha
Icon for Helper I rankHelper I
8 years ago
Solved

Filter and sum

Hi  Table  Company Sales  x              200 y              100 x               50 z              150 z               80     I want to calculate the total sales of a company / sum of all sa...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    Hi bvsaicharitha,

    could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

     

    Regards,

    Daniel He

bvsaicharitha's avatar
bvsaicharitha
Icon for Helper I rankHelper I
8 years ago

Hi, 

Can you please explain me why you used max function to filter the name of the company which is text?

MAX returns the largest numeric value right?

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi bvsaicharitha,

The max function is an aggregate function, it could be used in the formula to filter the content of a column, not only the numeric value, you could also filter the text, date, time and other contents.

 

Regards,

Daniel He