Forum Discussion

pcowman1's avatar
pcowman1
Helper I
7 years ago

Summarize to Index Table

I am having a problem with the following:

Item Summary has a one to many to Sales Order on the Item Number.

I need to create 2 columns:

Immediate Requirement = Inventory Quantity - Sales Order Quantity

Projected Inventory = Immediate Requirement - Safety Stock

 

However, I still need to be able to filter Sales Order Quantity on the Shipment Date.

If I add Inventory Quantity and Safety Stock to the Sales Order it gives me extra of each number because of the extra lines in the Sales Order.

 

Is there a way to do this through creating a new table or ????

Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    Hi pcowman1 ,

    Could you please share the expected result and sample data to us for analysis? 

    >>However, I still need to be able to filter Sales Order Quantity on the Shipment Date.

    In this scenario, we can create another visual which contains Date and use sum() to calculate the total of Sales Order Quantity, 

    Best Regards,

    Teige

    • pcowman1's avatar
      pcowman1
      Helper I
      7 years ago

      Hi,

       

      I actually found it by doing things a different way with measures.