1 of 1 people found this helpful
It could be relatively easy depending on the shape of the data coming into Tableau. Here's a similar chart using the sample Superstore Sales data provided with Tableau. Given the shape of that data, the solution was slightly more complex and required a table calculation. Your data may be slightly easier to work with. If you have any questions on my solution or if you'd like me to look at some other sample data, I'd be happy to!
Thank you so much. The solution is almost close to what is needed.
One thing is missing here. I would like to display national average too on the same line.
Can we do this? The calculations are happening at State Level. So Can we calculate national average here?