using P E for market basket analysis

[ilanbaruch]

hi all

in my model i transaction table 

with fields : id, item, quantity ... etc.

loaded this table again with the fields : id, item_1

so the connection between the main table and the secondary is id.

in UI i want to use an expression to  count (id) and sum (quantity) of all other items from the user selection in item_1

any ideas ?

advanced thanks

[Akhil_Reddy · Accepted solution]

=count( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} id)

=sum( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} quantity)