Data Grand Total in Pivot Table Row Area

S

stuart62

I am creating a Pivot Table over sum of Balance Due in Data area of a
pivot table. In the row area of the pivot table I have a Credit Limit
Field and the user would like the total overall balance due in the row
area next to this field. Is it possible to get the total of Balance
due in the row area. Thought I could use Calculated Field but that can
only be used to add to the Data Area and calculated item requires the
field already to be in the row area. Anyone have any suggestions?

Is it possible to get the Grand Total of the Data added to the Row
Area?

Stuart
 

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

Similar Threads

Average of Subtotals in Pivot Table 0
How to ignore a column of numbers in Grand Total for rows 1
Excel 2007 - Pivot Table - field calculation help 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Tables by Macro 2
Pivot Table Field based on two data area fields 3
2007 Pivot table Calculated field misbehaving 1
Pivot Table Sub total and totals 4

Top