In given sheet i have Opening (A) , Total (D) and Closing (G).
Opening (A) = Previous day closing value (G)
Total (D) = made with A + C
Closing (G) = made with D+ E
Now i getting issue with make above formula in tableau .
for reference excel sheet is attached. The same sheet was make into tableau with online data
and this sheet is use for every month and shows whole month date wise data in given format
9 respuestas
What you are doing is similar to an inventory analysis - I have a solution to the inventory analysis on my tableau public site - see https://public.tableau.com/app/profile/jim.dehner/viz/DetermineEndingInventoryBalance/Display it inlcudes how to instructions - you can use it as a model for you specific situation
