Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
List box expression:
=Aggr(If(sum(Amount)/VAmount*100>13,SalesPerson),SalesPerson)
List box expression:
=Aggr(If(sum(Amount)/VAmount*100>13,SalesPerson),SalesPerson)
Hi Balraj,
PFA and check the new list box.
Marc.
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