5 Replies Latest reply on Dec 7, 2017 10:17 AM by Joe Oppelt

    Pulling data from one row to another


      Hi, I have an interesting situation where I have two products that are supposed to have the same number of products. Product A and B are related. They have the same number of accounts but in the database, Product B's numbers are off.


      Is there a way for me to create a query or calculation in Tableau where I can say that for Product B, I will be pulling in Product A's data? Complexity does not matter as long as I can do this. Also, I do not rely on the number of accounts for any other calculation in this situation so I do not mind showing a dummy sort of number if that's possible/the only way.




      ***EDIT***: I believe the solution of this would have to do with a CASE but can't figure out how to get it to work.