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 Table in Excel 2003
Pivot Table in Excel 2003
Resolved · Medium Priority · Version 2003
Thu 24 Jun 2010, 07:40Delegate Ranjit said...
Ranjit has attended:
Excel Advanced course
Pivot Table in Excel 2003
My data in pivot table contains the following information;
Gordon Gin -
Packed 12 x 700 ML 22 cases
Packed 6 x 700 ml 52 cases
packed 700 ml 1865 bottles.
There are numerous other articles containing similar information.
What formulae do i use in the pivot table to convet these to the following
1. bottles or cases of 6
2. 9 liter cases
Ranjit
Wed 30 Jun 2010, 13:02Trainer Jacob said...
RE: Pivot Table in Excel 2003
Hi Ranjit
Thank you for your post and while we are reasonably confident we can assist you we would need to speak with you directly to better understand your requirement.
If you are around this afternoon one of us can call, once we have talked with you we can establish a solution. If it takes 5 minutes we will get back to you, however if it looks to be more involved then we may need to have dedicated trainer time with associated costs. We will always advise on what the next steps are and wait on your decision.
regards
Jacob
Wed 7 Jul 2010: Automatically marked as resolved.
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:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |
