Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Issue re ManufacturerReport pivot data analysis

	98.1 % recommend us
	More live stats...

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

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Issue re ManufacturerReport pivot data analysis

Resolved · Medium Priority · Version 2003

Reply Fri 28 Aug 2009, 16:24Delegate Darren said...

Darren has attended:
Excel VBA Intro Intermediate course

Issue re ManufacturerReport pivot data analysis

Simon,
re 'Delegate Training File Darren' you have copied, the pivot analysis for ManufacturerReport is adding the data as count rather than sum. Can't understand why this is the case when the exact coding for SalesPersonReport is correctly adding pivot analysis by sum. Could you please assist? Thanks, Darren.

For upcoming training course dates see: Pricing & availability

Reply Thu 3 Sep 2009, 20:20Trainer Simon said...

RE: Issue re ManufacturerReport pivot data analysis

Hi Darren,

I am sorry I haven't replied earlier but I have been training solidly.

However, I am looking at the problem and when I find the rogue lines of code I will email you.

Regards

Simon

Reply Tue 24 Nov 2009, 01:07Trainer Simon said...

RE: Issue re ManufacturerReport pivot data analysis

Hi Darren,

Sorry for the delay in responding.

I have been over the code a number of times and cannot see where the problem line is.

I am sorry I couldn't answer the query.

Regards

Simon

Reply Tue 24 Nov 2009, 20:26Delegate Darren said...

RE: Issue re ManufacturerReport pivot data analysis

Hi Simon,

No worries, thanks for trying to find a solution.

Regards,
Darren.

Excel articles

· A Hidden Gem In Excel - Formula Auditing
· Data Validation In Excel
· How To Pick The Best Chart Type In Excel
· How To Use Functions In Excel 2010
· Why Should I Learn Visual Basic in Excel?

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

Excel tip:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips