9 Replies Latest reply: Jun 8, 2012 12:08 PM by Thomas Skariah

# Subtotaling

Hi All,

Can anyone give an idea of how to calculate totals of two different rows into one.

For better understanding please view the attached image.

Regards

Tom

• ###### Subtotaling

Hi Tom,

<Show Partial Sums> may do this. Let do it by Right Click on Pivot Table ==> Properties ==> Presentations ==> Check on Show Partial Sums

Apologize if I misunderstood your question.

Regards,

Sokkorn

• ###### Re: Subtotaling

Hi Sokkorn,

Thanks for your reply, but with partial sums it given totals of individual rows and in my scenario i need totals of  A and B.

Please see the question mark given in the image.

Regards

Tom

• ###### Re: Subtotaling

Hi Tom,

Can you share your app? We look into it together.

Regards,

Sokkorn

• ###### Re: Subtotaling

Hi Sokkorn,

Please find the attached sample Application.

Regards

Tom

• ###### Re: Subtotaling

Get back you soon after meeting

• ###### Re: Subtotaling

Any one ,any Idea?

Regards

Tom

• ###### Re: Subtotaling

Hi Tom,

See the sample attached file.

Regards,

Sokkorn

• ###### Re: Subtotaling

HI,

Thanks a lot Jonathan and Sokkorn for your kind support.

Regards

Tom

• ###### Re: Subtotaling

Tom

This is usually done by adding a grouping field that groups A and B together, and then including that field as the first dimension.

You could create the field in script, or use a calc dimension, which could look like this (assuming A, B, ... are a field called Field1):

=Pick(Match(Field1, 'A','B','C','D'), 'A+B', 'A+B', 'C', 'D')

After you add in this calc dimension (let's name it Grouping' for the sake of example), enable the partial sum for Field1. This will create subtotals for 'Grouping' similar to your illustration.

Hope that helps

Jonathan