Have you reviewed the material in the Excel 2008 Help on Pivot Tables?
After that, there is a tutorial here:
http://office.microsoft.com/en-us/excel/ha010346321033.aspx
And some samples here:
http://office.microsoft.com/en-us/excel/HA010346331033.aspx?pid=CH0107140110
33
You need to start yourself off: we can't help you until you have your source
data defined. We can only respond to your specific questions in here: we
need you to start the process first.
What I am trying to say is "Your question is asking us to do the job FOR
you. Many people helping in here do commercial Excel coding for a living,
so that's a bit like asking your Bank for free samples
"
Hope this helps
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I need help creating a pivot table from two seperate tabs. I want to use a
pivot table to show a summary by category of the net effects that event sales
and returns have on inventory. I need to be able to explain what
increases/decreases inventory quantity and value balance and I also need to
provide ending inventory quantity and value balance by category (beginning
balance on 'Category Assumptions' tab).
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:
[email protected]
