Grand Totals for Pivot Tables


E

ExcelPeter218

I have a Pivot Table based on a Table that consists of the following fields:
Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4

When I create the Pivot Table using the Insert->Pivot Table feature I
specify Provider and Date as Row Labels and Sum of each of the Pmt fields as
values.
The resulting table has a Grand Total at the bottom for the columns but I
cannot get a Grand Total for the rows at the right. When I the Totals &
Filters tab under Pivot Table options both Grand Total boxes are checked.

Is there a way the get both Grand Totals at the same time.

Any advice would be greatly appreciated.
 
Ad

Advertisements

D

Debra Dalgleish

You'll only see a Grand Total for rows if there's a Column Labels field.
Then, it will show a total for each Value field, for each column field.

You have multiple Value fields, and a Grand Total for rows won't show a
total for those.

Perhaps you could create a Total Pmt column in your source data, and add
that to the pivot table.
 
Ad

Advertisements

B

Boater

That fixed it thanks very much

Debra Dalgleish said:
You'll only see a Grand Total for rows if there's a Column Labels field.
Then, it will show a total for each Value field, for each column field.

You have multiple Value fields, and a Grand Total for rows won't show a
total for those.

Perhaps you could create a Total Pmt column in your source data, and add
that to the pivot table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top