can u define what this subtotal 1,subtotal 2 here..
try with calculated items
for example cacluated item one Sub1=Asia+Europe
caclated item two sub2=Asia+Europe+America and as usual put row level grand total to get Total
Thanks for the reply.
Here Subtotal will sums up the rows basing on other column (Dimension).
SubTotal 1 sums the rows basing on the another dimension( value A and value B). SubTotal 2 sums the rows basing on aother values(values C and values C.
I understand the above solution, but that is not enough to my requirement as I need to show Regions for Subtotal 1, but not for Subtotal 2. And these Subtotals are based on another column (other than Regions).
Hope this is clear now.