software

hi all!

i am having a database of sales turnover for differenct products of
different companies for a period as under:

COLquot;Aquot; - MONTH amp; YR
COLquot;Bquot; - COMPANY NAME
COLquot;Cquot; - PRODUCT NAME
COLquot;Dquot; - UNITS SOLD
COLquot;Equot; - VALUE SOLD

JAN05 - X - XX - 10 - 1000
JAN05 - X - XXX - 5 - 400
FEB05 - Y - YY - 20 - 500
MAR05 - X - XX - 5 - 500
MAR05 - Y - YYY - 10 - 600
MAR05 - X - XXX - 20 - 2000
|
v

|
v

what i want is to extract the periodwise, companywise, productwise
totals of units sold (COLquot;Dquot;) amp; value sold (COLquot;Equot;) and export it to
another worksheet under the same column headings so that i can create a
pivot table for further analysis!

is there any easy way to achive this thru xl formula or by any other
method?

expecting help!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=507355I'm not sure I understand your question. The data structure you described
seems perfect for a Pivot table that would give you the Total Units and
Total Sales for every Period, Company and Product.

If you want to do further analysis, you can always base a 2nd pivot table on
the 1st one.HTH,
--
George Nicholson

Remove 'Junk' from return address.quot;via135quot; gt; wrote in
message ...
gt;
gt; hi all!
gt;
gt; i am having a database of sales turnover for differenct products of
gt; different companies for a period as under:
gt;
gt; COLquot;Aquot; - MONTH amp; YR
gt; COLquot;Bquot; - COMPANY NAME
gt; COLquot;Cquot; - PRODUCT NAME
gt; COLquot;Dquot; - UNITS SOLD
gt; COLquot;Equot; - VALUE SOLD
gt;
gt; JAN05 - X - XX - 10 - 1000
gt; JAN05 - X - XXX - 5 - 400
gt; FEB05 - Y - YY - 20 - 500
gt; MAR05 - X - XX - 5 - 500
gt; MAR05 - Y - YYY - 10 - 600
gt; MAR05 - X - XXX - 20 - 2000
gt; |
gt; v
gt;
gt; |
gt; v
gt;
gt; what i want is to extract the periodwise, companywise, productwise
gt; totals of units sold (COLquot;Dquot;) amp; value sold (COLquot;Equot;) and export it to
gt; another worksheet under the same column headings so that i can create a
gt; pivot table for further analysis!
gt;
gt; is there any easy way to achive this thru xl formula or by any other
gt; method?
gt;
gt; expecting help!
gt;
gt; -via135
gt;
gt;
gt; --
gt; via135
gt; ------------------------------------------------------------------------
gt; via135's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26725
gt; View this thread: www.excelforum.com/showthread...hreadid=507355
gt;

yes..Mr George!

i am able to construct a perfect pivot table with the data available
with me!
only thing is i am not able to filter results at my choice using the
drop down menu available in the filed names. for ex. if i want the
turnover for a period between given months what is the way? becoz there
is no custom option available in the dropdown menu!

pl help!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=507355