My goal is to create a line chart to show the total value of the historical inventory value amounts. However, I am using two data sources that do not join or blend on any linking field.
One data source only has our current inventory value (this is the only field, it is constantly updated to show the value of our inventory as of today).
The other data source shows the increase and decrease values in inventory over time.
Since I only have the current inventory value, I'm trying to take that value and subtract the net increase/decrease amount to get the total inventory value of the previous week and so on.
I've attached an Excel with example data as well as a Tableau workbook. In the workbook, I created a chart that is similar to what I am trying to make, but instead of the line being a straight line, it will reflect the changes
Thank you to anyone who takes a look at this!! I've been trying to figure this out for so long!
Hi Jim,
Thank you for your response! That solution is close, however I was looking to subtract by a backwards running sum.
I figured out the solution with this calculation:
IF LAST()=0 THEN SUM([current inventory tab].[Current Inventory Value])
ELSEIF SIZE()-INDEX()>=1 THEN SUM([current inventory tab].[Current Inventory Value])-WINDOW_SUM([Net Value],1,LAST())
END
Thank you for your time and effort looking into this.
