98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Issue re ManufacturerReport pivot data analysis | Excel forum
Issue re ManufacturerReport pivot data analysis | Excel forum
Resolved · Medium Priority · Version 2003
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.
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
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding date and timeHere are two quick ways to add the date and time to your spreadsheet: |
