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
@James Emery Sir, Thanks for reply.
We have three column
A = Opening Stock (That is closing of previous day)
B = Total (That is Total of "PI Taken for Production after adjusting the available stock + Opening Stock")
C = Closing = Balance against PI (1) (That is Total of "Produced Qty(PD)+ Total" )
Now when we use total in closing balance then got "Circular Ref."
now how can we resolve this problem
This is inventory problem
where we have Opening , Total and Closing and they all are linked with each other.
in Excel its easy but in tableau how can solve these type of problem.
