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

@Tejaswini_Yadav

Can you share screenshot of how your data appears?

Thanks

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

@Tejaswini_Yadav

Check below for your reference

Hope this may help you

Thanks

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.