Subtotaling

[thomas_skariah]

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

[Sokkorn]

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

[thomas_skariah]

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

[Sokkorn]

Hi Tom,

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

Regards,

Sokkorn

[thomas_skariah]

Hi Sokkorn,

Please find the attached sample Application.

Regards

Tom

[Sokkorn]

Get back you soon after meeting

[thomas_skariah]

Any one ,any Idea?

Regards

Tom

[jonathandienst]

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

[Sokkorn · Accepted solution]

Hi Tom,

See the sample attached file.

Regards,

Sokkorn

[thomas_skariah]

HI,

Thanks a lot Jonathan and Sokkorn for your kind support.

Regards

Tom