Sales order in excel

  1. Calculates the total sales for each region
  2. Displays, in a message box, the region with the most sales and the region with the least sales, with the corresponding sales amounts


Can you share screenshot of how your data appears?


Hi @Tejaswini_Yadav ,

Can you share that excel or the screenshot?
I want to see how the data looks like before providing any soln.

i need to display in message box least sales region and high sales region in string

Hi @Tejaswini_Yadav

Provide the excel screenshot so that we will know your excel data,
also give eg of input and output you want


Check below for your reference

Hope this may help you


You can use below expression

dt.AsEnumerable.Where(function(y) y(1).ToString = dt.AsEnumerable.Max(Function(x) x(1)).ToString)(0)(“Units”).tostring

Hi @Tejaswini_Yadav ,

Is it worked for you ?

no showing error :pensive:

What error you are getting ?

getting error like this

But this is on different activity not on the linq.