Calculation of Subtotals

[#1]

Hi All, 

I would like to calculate 2 subtotals as given in screen shot. The formula which we have used is

=if(Dimensionality() = 2 ,
if (Order =1,
Sum({$<Order={1}>} (HSL)/1000*(-1)),
if (Order =2,
Sum({$<Order={2}>} (HSL)/1000*(-1)) + Sum({$<Order={1}>} (HSL)/1000*(-1))
))
,(Sum(HSL)/1000)*(-1)
)

HSL is amount field

Please let us know where we have to make changes, your help will be appreciated.

Regards

LSD

[#2]

Goto presentations tab in your pivot table, select the column by which you need the subtotals by. Select "Show Partial Sums" check box.

You need not use a script to achieve this