- Calculates the total sales for each region
- Displays, in a message box, the region with the most sales and the region with the least sales, with the corresponding sales amounts
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
Provide the excel screenshot so that we will know your excel data,
also give eg of input and output you want
You can use below expression
dt.AsEnumerable.Where(function(y) y(1).ToString = dt.AsEnumerable.Max(Function(x) x(1)).ToString)(0)(“Units”).tostring
no showing error
What error you are getting ?
getting error like this
But this is on different activity not on the linq.