Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 2nd, 2006, 03:47 AM
Registered User
 
Join Date: Jun 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default PIVOT TABLE Grand Total ... pls help !!!!

Hi,
in a pivot table I need to customize grand total calculation. Is it possible programatically in VBA? What I need is to calculate MARGE:

Revenue BusCat1 10 12 34 54 43 21
         OEF 10 13 35 10 01 02
         SUBTOTAL 20 25 69 64 44 23

Cost BusCat1 12 12 32 22 23 32
         Constract 02 03 10 13 14 10
         OEF 15 12 20 10 10 02
         SUBTOTAL 29 27 64 45 47 44

Marge -9 -2 05 19 -2 -21

Grand Total is possible, but only as a sum, not minus.
Thanks for help, im really hopeless.





Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating grand total blkskullwork Javascript 2 December 18th, 2006 10:36 AM
PIVOT TABLE Grand Total ... pls help !!!! laky Access 0 June 2nd, 2006 02:15 AM
pivot table without total thelos Excel VBA 1 September 23rd, 2005 11:40 AM
Grand Total mateenmohd Access 6 April 8th, 2005 07:30 AM
label cant display total value... pls help life_s Ng General .NET 2 August 20th, 2004 02:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.