Please try the following steps..
Step 1: Place the state Dimension in the Rows
Step2: Place the measure 2014 in Columns
Step3: Sort the state Descending order( you should have the below output)
Step4: Place the measure 2014 in Columns next to the existing Sum(2014) measure
Step5: Right click on the second Sum(2014) measure in the column and “select add table calculation”
Step 6: Do the below table calculation
Step 7: Right click on the Second Sum(2014) measure and choose “Dual Axis” (Now your pane will convert to circles visualization)
Step 8: Right click on the first Measure Sum(2014) and select Marktype= Bar
Step 9: Right click on the second Measure Sum(2014) and select Marktype= Line
Step 10: click on the menu bar label “Abc” icon to show the labels for each bar and line graph data points
Step 11: click on the swap button if you want to change the vertical graph to horizontal
Also please find the attached Tableau workbook I have used.
Hope this will help you
Running Total.twbx 356.0 KB
Hi Indumon --
Thanks for your help.
There is still one thing that I don't know how to do.
For the data displayed where mark type = line, currently at each point
on the line, the 2014 population for each state is visibly displayed.
See the attached screenshot.
I do not want this.
That information is already shown on the bar chart marks so I do not
need to show the same information twice.
Instead, on the line, I want to visibly display for each point on the
line a percentage.
This percentage should correspond to the "% of Total Running Sum of 2014
along State" as displayed in the little tooltip box in the attached image.
However, I don't want to force the user to hover over the data point to
see the percentage. I want the percentage to show up next to each point
on the line graph.
Thanks so much for your help!!! I really appreciate it.