1 of 1 people found this helpful
first welcome to tableau and the forum
it is good practice to include a workbook in a TWBX format with your question so we can see the actual data and its structure
using a superstore example see below
I determined the average selling price (sales/quantity) by year and then the variance YOY
the Variance is a table calculation
this is the result
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks Jim, very thorough response with ample visuals and detail to walk through for a new user. Due to data content I would have had to scrub it first, so I was hoping to avoid that step. Any recommendations for scrubbing/masking data quickly for posting for future questions?
Glad to help out