Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
try expression
Sum({<Client ={"=sum(Amount)>=50 and sum(Amount)<=500"}>}Amount)
Use this..
May be like attached
chk attachmnt