One way you can do this is to create a second version of the data.csv file that is connected to your workbook currently. Then, copy and paste the data from the R column into the Funding column.
Then, open the Tableau workbook, connect to the new file. Right click on the original data source, and select Replace Data Source.
Hope this helps!
When I try doing this, I get the error message "the worksheet "list of businesses" contains errors. Do you get this when you run it? How do I work around this?
See the attached workbook with the solution using your Enrollment.csv file. See there are two new worksheets: Filled Map AVG, List of Schools; and one dashboard called Dashboard 2 that are using a new connection to the data source Enrollment.csv
I suggest you to carefully review the workbook particularly the worksheet of the map to learn how to do it.
I hope this helps,
PS. Don't forget to mark the thread as Correctly Answered.
Funding_v2.twbx 920.8 KB