4 Replies Latest reply: Mar 10, 2017 3:41 AM by kaan erisen RSS

    Set Analysis Question

    Siddharth Gupta

      Hello All,

      I have 4 fields

      WeekPlantNet PriceOrder Quantity
      1BID123.0016
      1BID122.0014
      1CAL124.0012
      1TAP120.0022
      2TER133.0041
      3REP127.0015

       

      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!