Grouping in set analysis

[madhuqliklondon]

Hi Friends ,

I am trying to get grouping done in expression level. What I got in attached file is I am trying to understand free item offers making customers buy products and calculating their associated products. With the help of stalwar1‌ I got to this point , now I am trying to do is group items by brand in order level it self and I do not want to calculate  other products in that order for example in order number 1

(see attached) totals of Sony only leaving other products because I want to calculate bundle offers as the promotion. Mostly same brand products are higher in an order , other brands products are less any way if this gives any ideas. Please select free on filter.

expected results: 

item	quantity	totals
lg 3d glasses	1	550
samsung ear phones	1	650
sony ear phones	1	300

Thanks in advance .

[sunny_talwar · Accepted solution]

May be this

Sum({<product_type={'free'}>}

  Aggr(

  Sum(TOTAL <[order number], brand> {<[order number] = P({<product_type={'free'}>}[order number]),product_type>}[amount])

  ,[order number],item.no, brand))

[madhuqliklondon]

Thank you Sunny(Super Star).

[madhuqliklondon]

Hi Sunny,

Can you explain in simple terms what the expression is doing ?

[madhuqliklondon]

stalwar1‌ Sunny,

When you have free time please explain.

Many thanks