Add expression into list box

[samantha92]

Hi everyone,

I have created an expression in a straight table and i would like to add this into a list box so that users are able to filter via the list box.

I have tried numerous ways to add this expression but i know that it wont accept TOTAL.

Is the only way to achieve this by doing a GROUP BY in my script? Will this not affect all of my query?

Here is my expression:

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >'250.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='500.00','2) £250 - £500',

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >='0.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='250.00','1) < £250'))

Any help is much appreciated

Thanks

[tresesco · Accepted solution]

Try like:

Aggr(

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >'250.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='500.00','2) £250 - £500',

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >='0.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='250.00','1) < £250'))

, dim1, dim2..)

dim1, dim2.. would be your chart dimensions that the aggregation is carried out against.

[sunny_talwar]

If what tresesco‌ gave doesn't work, would you be able to share a sample?

[samantha92]

Yes it works!

Thank you so much for your help