Hi Manoj,

One possible way this can be done would be by using the suggestion from Andy here:

Grand Total in First Row

Another suggestion can be found here:

How do I move the location of the "Grand Total" row to the top

Re: Grand Total at top of report

There is also an idea you may want to vote up here:

http://community.tableau.com/ideas/1320

-Tracy

I'm not sure any of those suggestions will work for this view, since there are multiple years in the view and he is actually wanting his "Subtotals" to come first in a series of dimension values.

I believe you can edit your data source with some Custom SQL to add a "subtotal" member to your Dimension, but I'm not very good at this type of thing. 

You might find a solution in one of these threads:

Customizing Grand Totals – Part 3 | Drawing with Numbers

Re: Formatting Question - Can the Grand Row Totals be shown on the left side of the view?

How do I move the location of the "Grand Total" row to the top

To modify the SQL to get a subtotal you could do the following:

SELECT

  [Table].[Container] AS [Container],

  [Table].[Order Date] AS [Order Date],

  [Table].[Profit] AS [Profit]

FROM [Table]

UNION ALL

(SELECT

  "Total" AS [Container],

[Table].[Order Date] AS [Order Date],

  sum([Table].[Profit]) as [Profit]

FROM [Table]

group by [Order Date],[Container])

This will give you a rolled up total value for each date/Category.

The output will look like the following: (I removed the table calc cause I'm not sure what you're trying to do so I'm keeping things simple.

If you describe more about what is needed I can show you how you can use table calcs "around" the subtotals.

After looking at your requirement more, I don't know that the Custom SQL route is the greatest.  It does give you a placeholder though for "Totals" that can be moved to the left.  After this you could use calcs to determine totals for whatever window you specify.

This is an example that does some tricky calculations to get the running sum of profit totals, although, conceptually, asking this from a visual is very confusing.  You're putting the running sum total in from of marks that that total will contain.

If this is closer to the output you're looking for then I can walk through the calcs.

Yep, you need to not account for your totals in the running sum.

Computed Running Sum:

if attr([Container]) = 'Total' then previous_value(1) else sum([Profit]) + previous_value(1) end

This "skips" the "Total" field and keeps the position of the last field of the previous pane.

Set the compute using to pane across.