Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot tables

Resolved · Low Priority · Version 2007

Reply Tue 10 Aug 2010, 16:39Delegate Lynne said...

Lynne has attended:
Excel Advanced course

Pivot tables

can you change the grand total column so that it takes the difference between 2 of the data columns e.g. to see year on year improvement

For upcoming training course dates see: Pricing & availability

Reply Thu 12 Aug 2010, 02:09Trainer Anthony said...

RE: pivot tables

Hi Lynne, thanks for your query. You can't change the nature of the grand total column because that is wired into the pivot table tool itself. However, you could create a custom calculated field which would perform a difference calculation and which you could then add to the pivot table in place of the grand total column.

Hope this helps,

Anthony

Excel articles

· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Benefits of learning about Excel charts
· What Do The Formula Error Messages Mean In Excel?
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Creating Error Alerts In Excel Using Data Validation

Please browse our web site to find out more about
advanced excel class and other Microsoft training courses.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy