T
Too much data
I am using Power Pivot to show the items dispatched and the cos
incurred for a year. What I ideally want is a pivot with the followin
layout
Customer A Order B Widget C Dispatched 01/01/12 Qty10 (Then cos
broken down by month)
I also want a sum on the quantity of Widgets as we may dispatch severa
quantities of widgets.
I have linked two tables of values in order to achieve this. The firs
table has the actual items dispatched with quantities etc and the othe
has the financial cost associated with the dispatch. I have linked the
arrays of data by a unique dispatch ID and not used vlookup on th
dispatch data as there is usually more than one financial transactio
per dispatch (so I wont capture all the costs). I can’t use vlookup o
the financial data as I will double (or treble) up the quantities i
there are 2 (or 3) financial transactions per dispatch). There is ofte
additional financial data lines relating to a dispatch when the cost ha
been amended retrospectively
I have attached what I have so far I am almost there but I have a qt
per month when I just want the qty dispatched listed first and not ever
month
+-------------------------------------------------------------------
|Filename: Capture.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=292
+-------------------------------------------------------------------
incurred for a year. What I ideally want is a pivot with the followin
layout
Customer A Order B Widget C Dispatched 01/01/12 Qty10 (Then cos
broken down by month)
I also want a sum on the quantity of Widgets as we may dispatch severa
quantities of widgets.
I have linked two tables of values in order to achieve this. The firs
table has the actual items dispatched with quantities etc and the othe
has the financial cost associated with the dispatch. I have linked the
arrays of data by a unique dispatch ID and not used vlookup on th
dispatch data as there is usually more than one financial transactio
per dispatch (so I wont capture all the costs). I can’t use vlookup o
the financial data as I will double (or treble) up the quantities i
there are 2 (or 3) financial transactions per dispatch). There is ofte
additional financial data lines relating to a dispatch when the cost ha
been amended retrospectively
I have attached what I have so far I am almost there but I have a qt
per month when I just want the qty dispatched listed first and not ever
month
+-------------------------------------------------------------------
|Filename: Capture.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=292
+-------------------------------------------------------------------