What's your question exactly?
If you're looking for further help on how to build the chart for your scenario, please upload a Tableau Packaged Workbook.
Regarding packaging up the data, there is confidential information in the file. So, I'm not sure how to avoid that..... On the other hand.
I need a "parameter/filter/calculated field"?? to change the selection of a chart. As previously mentioned.. I do have a field called "Type of Business" with the following fields: New, New Goal, Renewal, Renewal Goal (to get total, you select all 4)
I would like a "new parameter/filter/calculated field " that has selection of New, Renewal and Total. If you select New, then New and New Goal are on the chart, if you select Renewal then Renewal and Renewal Goal are on the chart instead. If you select total then Total and Total Renewal are on the chart.
Right now I have 3 DB's to accomplish this.
Create sample data which has the same structure and upload a sample using that.
Generally speaking though, create a new parameter with a list of your metrics.
Then create a calculated field like;
IF [parameter] = "New" then SUM([NewField])
elseif [paremeter = "Renewal" then SUM([Renewal Field])