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 Training and help » Pivot Tables
Pivot Tables
Resolved · Low Priority · Version 2007
Fri 1 Jul 2011, 15:13Delegate Julie said...
Julie has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Pivot Tables
I have played with the daily sales spreadsheet in the Unit 4 practice activity. I have inserted a column where I have put Budget and Actual and copied all the cells and altered the budget amounts to be higher than the actuals and then done % diff from Budget. It works fine but when I filter the report filter by product code and just choose one product I get #DIV/0!
I presume this is because for example this product was not sold in Jan and March so it causes this error.
How do I get round this.
All Product codes AG07
Sales Values
Jan Feb Mar Apr
Central Actual #DIV/0! -9.09% #DIV/0! 33.33%
Budget
South Actual -33.33% #DIV/0! -9.09% #DIV/0!
Fri 1 Jul 2011, 15:42Trainer Rodney said...
RE: Pivot Tables
Hello Julie,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding the Unit 4 exercise. I have followed what you have done and also inserted a column for budget items with figures higher than the actual. I added a % Diff column and calculated the difference between budget and actual which of course gives me negative results.
I then created a PivotTable from this data and didn't get any errors. I added autofilter buttons to the main data sheet and tried all sorts of filters and still did not get any errors.
Please will you send me an email with the file attached so that I can see what you have done and I'll come back to you as soon as possible. My email is:
rl@stl-training.co.uk
I look forward to your reply, and wish you a great weekend.
Regards,
Rodney
Microsoft Office Specialist Trainer
Training information:
See also:
|
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:Creating Quick Column ChartsSelect the information you want to appear in the chart and press F11. This creates a new chart on a seperate worksheet. |
