i run a e commerce business that deals with a lot of one time inventory buys as well as replenishable items. I'm trying to forecast my sales based on inventory on hand. For example
Sales in the last 30 days. $10,000
Qty Sold 100
inventory On Hand 500
im looking to design a report that would have the months at the top and the SKUS on the side and it should look like this
SKU .Jan. Feb. . March. . Apr. May Jun
ABC $10000 $10000.$10000. $10000 $10000. $0
so June would show $0 since my inventory would of ran out by then
Would it be possible to upload a sample workbook (.twbx) or a subset of the underlying data? The solution will probably depend on how the columns in the underlying data are set up.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...