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