1. Tableau is a read-only application. It will never insert any data into a db. "Alternative columns" sounds like just creating a calculated field to show different values in the view? Not sure exactly what is needed.
2. Totals are based upon the underlying data in the view and not on the level of detail. If you are seeing something unexpected it may be necessary to use a table calc or a LOD calculation. http://onlinehelp.tableau.com/current/pro/online/mac/en-us/help.htm#calculations_totals_grandtotal_aggregations.html
Let me see if I understand your example, the Scenario Names are the records and the SaleAmts are the fields?
If so, you can only insert new fields on the Tableau side but not new records.
Also, note that the new inserted fields will remain in tableau and will not appear in the raw data, as stated by Cor Bader "Tableau is a read-only application".
Below is an example that would give you the data you are looking for, but it is quite an eyesore.
Try adding the new fields by doing the following to each sum(SaleAmt)
Quick Table Calculation: Difference
Relative to: First
And then re-add the Sum(SaleAmt) to the measure values card.
For the scenario total, just do a calculated field:
Many thx, Cor, and Joshua for all the details!! I am new in this -- is there any way to insert as alternative "columns", instead of alternative "rows"? sorry for my ignorance. Thx again!
Namely, b/w ScenarioName2 & ScenarioName3, ScenarioName3 & ScenarioName4...
To be more detailed, would like to calculate (ScenarioName2's value - ScenarioName1's value) / Total for ScenarioName1's value, namely, ($7M-$2M)/$9M.
Then same for (ScenarioName3's value - ScenarioName1's value) / Total for ScenarioName1's value
Then insert the new columns (showing %) b/w ScenarioName2 & ScenarioName3, ScenarioName3 & ScenarioName4...
To be more clear --
I would like to calculate (the cell ScenarioName2/SaleAmt1's value - the cell ScenarioName1 / SaleAmt1's value) / Total for Baseline ScenarioName1's Value, namely, ($7M - $2M)/$9M.
Then same for (the cell ScenarioName2/SaleAmt2's value - the cell ScenarioName1 / SaleAmt2's value) / Total for Baseline ScenarioName1's Value, namely, ($7M - $3M)/$9M...similarly to continue...
Then insert the "new calculated fields" (showing %) b/w ScenarioName2 & ScenarioName3, ScenarioName3 & ScenarioName4...
Thx millions for the inputs!!