set analysis help required

[#1]

the below one works

=Sum({

<[Customer Name] = {"=Sum(Sales) <= $(vSlidemax)"}>

}Sales)

in the hilighted string , i have to add this condition  >=$(vSlidemin)

it means i need sum(sales)  between $(vSlidemax)  and $(vSlidemin)

thanks in advance

[sunny_talwar · Accepted solution]

Try this:

=Sum({<[Customer Name] = {"=Sum(Sales) >= $(vSlidemin) and Sum(Sales) <= $(vSlidemax)"}>} Sales)

[Anil_Babu_Samineni]

Perhaps This

=Sum({<[Customer Name] = {"'>=' & $(vSlidemin) '<' & $(vSlidemin)"}>} Sales)

OR

=Sum({<[Customer Name] = {"'>=' & '$(vSlidemin)' '<=' & '$(vSlidemin)'"}>} Sales)

[#4]

it works. thank you

[sunny_talwar]

Anil you cannot compare Customer Name to a min and max date range my friend. This is not the right way to do it brother.

[Anil_Babu_Samineni]

Ok Bro, Thanks for recommend me

[#7]

sorry  anil.

it is not working for me

[sunny_talwar]

No problem