Range selection

[paulwalker]

HI Community,

I facing one problem..

I would like to create range wise chart..

If I am give range From and to

I want to filter data..

Example:

Client,  Type, Amount

A, AC, 100

A, AC,200

A,AC,400

B,AC,30

B, AC, 50

C, AC, 250

C, AC, 45

Chart:

Client   Type  Sum(Amount)

A            AC      700

B            AC        80

C           AC        295

Here My requirement..

Range  From:   50

             To:      500

Output Should Be

Client   Type  Sum(Amount)

B            AC        80

C           AC        295

Thanks In Advance...

[Kushal_Chawda]

try expression

Sum({<Client ={"=sum(Amount)>=50 and sum(Amount)<=500"}>}Amount)

[MK_QSL]

Use this..

[sunny_talwar]

May be like attached

[Chanty4u]

chk attachmnt