I am trying to get values in a table sorted in intervals with statements.
Below is sample data, the Count(Assignments) and Count({<Volume = {'>=10'} >} Assignments) works well enough, but what i need is to have multiple intervals showing different volume values. That I can't get to work..
Country
Count(Assignments)
Count({<Volume = {'>=10'} >} Assignments)
Volume interval 1 - 10
Volume interval 11-50
Volume interval 51-100
SE
100
10
DE
200
20
US
100
10
FR
200
20
I was thinking that it needs to be an IF statement or some variation of the Count statement.
Example: Count({<Volume = {'>=1' and '<=10'} >} Assignments) - but that did not work
