Welcome to the community.
I believe you're looking for sub totals on ship mode and here is how it's done. I've attached the workbook with a new tab which shows how it's done.
You can also find more information here Subtotals,
Let me know if this is what you're looking for.
Subtotals.twbx 616.6 KB
Thanks for your quick response.
It works but the template is different than the one I posted. I need to have the years in column, then the ship mode beneath.
The last column needs to be the Total of all the years, split by ship mode.
Attached is your workbook with subtotals added via the Analysis menu.
Is this what you're wanting?
Between the two workbooks, hopefully you can get at what you want.
GT_Problem Subtotals.twbx 470.0 KB
I did swap the column but the subtotals are within each year.
I want to have :
2010 2011 2012 Total
Ship mode Ship mode Ship mode Ship mode
I need all the subtotals to be beneath the Total column, not in each Year column.
I agree that I have all the information I want, it's just it's not formatted how I want
You may not have all the information you need; I'm not quite sure what you're looking for as an end result (a mock up might help), but I'd certainly suggest you look over this 3 part series on Subtotals/Grand Totals in Tableau:
It may or may not cover your scenario, but it sure does help in understanding what's going on behind the scenes in Tableau.
Assuming I understand the request correctly, I don't think you can do that directly in a single view. You're essentially wanting each "sub-total" to appear at the end of the row with a column for each year, right? You don't have any control over where sub-totals appear, so you may need to do this in two views.
Is this the type of output you're looking for?
If so, this is done with two views. It may get you the results you're looking for, but it can also be a pain trying to keep things in synch between the two.
Almost Eric, see the image I attached in the post above.
I thought about doing 2 different views, but this is what I wanted to avoid ....
All right ! So 2 sheets and 1 dashboard.
Thanks everyone for your help, really appreciated.