Pivot

W

wollyka

Hi

I need an advice if possible on how to tag the problem the best
possible way.

I have the following tables (http://www.megaupload.com/?d=84Q0KUFB) in
different sheets that will be uased as master tables or raw data to
extract summary from them
For example, i want to know the average price of Brand X Type Y paid
by all companies, or what type of product is the most used by
companies etc...?

What is the most efficient way to do it? Pivot tables? is there any
other way? (since the layout of the pivot table isn't "appealing" :p )

i am open to suggestions (also if any changes to the tables itself
will make the work easier be my guest too)

Thanks for your help
 
Top