Subtotals in Pivot table

[#1]

Hi everyone,

Need to add subtotal in pivot table

I have a Pivot table like this:

But i need to show subtotals like the following:

Can anyone help me to find solution for the above requirement..

[MK_QSL]

Go to presentation tab

Select Source >> TICK Show Partial Sum

Select 2nd Dimension Which is Blank >> Tick Show Partial Sum

Select Subtotal At  Bottom

[jagan]

Hi,

Try like this

Chart Properties -> Presentation -> Click on Source and select Show Partial Sum

>> Click on 2nd Dimension (which is Blank) >> select Show Partial Sum

Hope this helps you.

Regards,

Jagan.

[#4]

Thanks for all reply.....

I need to add subtotal row like the following table:

PFA and help.....

[Anonymous · Accepted solution]

Hi

A simple method would be to create an inline Table using the Source field and giving the 'A-' records a value of 'A' and the remaining 3 a value of 'B'. Chose suitable field names to join with your main table. You can then use the new field with the A & B values as your first dimension and use subtotals on this field.

Regards

Dave

[#6]

Thanks David,

Similarly, I did this by adding same dimension again using Add calculated Dimension under Dimension.

[PradeepReddy]

Just drag the column to the top of the expressions columns and enable the partial sums option, you will ge the partial suma at right side of the chart.