Hello,
I have a table of customers who are on a recurring subscription setup for receiving my products.
Column A is the customer's unique ID number, Column B is the product name, C is the quantity of product I need to send them with each reorder, D shows in calendar days how often I need to send them product, and lastly E shows when their subscription was first created.
So for example my first customer in row 2 created their subscription on 8/2/2020, and gets one unit order of cherry bars every 60 calendar days.
My question is how do I use this data to create a demand pivot - showing me how many units of each product I will need to ship out each month - keeping in mind that some customers get their subscription every 7 days (so multiple times in each month), while others every 60 days (some months no product is shipped to them)?
Any guidance on how to accomplish this is appreciated. Thank you.
Starting Data
Starting Data.png
Desired Outcome Format
Desired Outcome.png
Bookmarks