Set Analysis Question

[#1]

Hello All,

I have 4 fields

Week	Plant	Net Price	Order Quantity
1	BID1	23.00	16
1	BID1	22.00	14
1	CAL1	24.00	12
1	TAP1	20.00	22
2	TER1	33.00	41
3	REP1	27.00	15

So set analysis which I am struck in is I want the calculation of PAN locations on the same week

Ex.

If I select week 1 and Plant BID1 so a table should show me same week but Plant CAL1 and TAP1 order quantity Calculations and total value(order qty. * net price) excluding BID1.

Do help!

[cgdonders · Accepted solution]

Hi Sid,

Try this: SUM({1<Week=P(Week), Plant-=P(Plant)>} [Order Quantity])

[kaanerisen]

Hi,

Is that what you want to get?

[#4]

Thanks to both of you kaan and Coen

Coen given me one correct and Kaan given me for second

thanks a ton both of you.

Also may I know what this P stands for?

[kaanerisen]

P is Possible and E is Excluded