Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Sid,
Try this: SUM({1<Week=P(Week), Plant-=P(Plant)>} [Order Quantity])
Hi Sid,
Try this: SUM({1<Week=P(Week), Plant-=P(Plant)>} [Order Quantity])
Hi,
Is that what you want to get?
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?
P is Possible and E is Excluded