Bar chart discussopn

[#1]

sales data on y axis and country on x-axis i want the data sum of sales range between 1000 and 5000 countries data only.

let me know any formula for range.

[#2]

Hello Mahesh,

you can use the Set analysis as below.

=sum( {$<Country = {"=Sum(Sales ) >= 1000 and Sum(Sales ) <= 5000"}>} Sales )

Thanks,

Shruthi

[MK_QSL]

CHECK attachment

[#4]

Thank u

mahesh t

[MK_QSL]

Can you close this discussion by selecting Answered or Helpful?