Question
How to calculate the remainning product numbers to be shipped based on the information of Order Quantity and Shipment Quantity?
Last Modified Date: 03 Jun 2022
Environment
- Tableau Desktop
Answer
1. Create the following calculation field Numbers to be shippedSUM([Order Quantity])-WINDOW_SUM(SUM([Shipment Quantity]),FIRST(),0)
2. Computes the above table calculation field within the dimension Ship Date.
3. Add Numbers to be shipped to the view
Additional Information
Table Calculation - WINDOW_SUMTable Calculation - FIRST
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials