How are you calculating that B =10? Is that the sum of the previous 10 values?
I took random numbers. The Goal numbers are based off the calculated field
IF [col1]='A' then '4'
ELSEIF [col1]='B' then '5'
ELSEIF [col1]='C' then '6'
ELSEIF [col1]='D' then '7'
Now I want to insert a row(duplicate) with col1=B and Goal=10 ? Can we do it?
Here it is
You need to Self Union your Data to add a new Row.
These are the Calcs I used
Then Finally You can Create This view if you Need with B=15
If It Helps, Pl mark it Helpful and CORRECT to Close Thread
Add a Row In Tableau.twbx 20.0 KB
Great! Thank you very much! Exactly what I was looking for..
One more thing, say if B>7 and I want to flag that particular row.
How do I achieve that now as B is coming from 2 sheets..
Please See attached (Sheet 3).
If It Helps, Please Mark it Helpful and CORRECT to Close THREAD, The CORRECT button is under my Reply in Your Main Thread, Not in Email
Add a Row In Tableau.twbx 24.7 KB
Awesome! Thanks again Deepak