Restriction on Dimension in List Box

[Anonymous]

Dear Experts,

I am having a dimension SalesPerson and now I need only those name in my listbox whose product mix(%) is greater than 13 %.

Please find the attachment and suggest.

Regards,

Balraj

[tresesco · Accepted solution]

List box expression:

=Aggr(If(sum(Amount)/VAmount*100>13,SalesPerson),SalesPerson)

[Anonymous]

Hi Balraj,

PFA and check the new list box.

Marc.

[its_anandrjs]

In a new list box write expression in expression properties.

=Aggr( if( (sum(Amount)/VAmount) > 0.13 ,  sum(Amount)/VAmount ),SalesPerson)

and in Number properties set settings