Forum Discussion

pcowman1's avatar
pcowman1
Icon for Helper I rankHelper 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 Qua...
Need Help
TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution 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
Icon for Helper I rankHelper I
7 years ago

Hi,

 

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