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!
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
