Calculated Table

[Itaybill]

Hi

i have a sheet with a lot of data, which include several columns, such as: width, length, number of items per job,customer name, industry, machine etc...

i would like to create a summarized table like this (columns here are statistical formulas)

filter:
customer name
industry
machine


Avg Min Max STDV Percentile
width
length
N of items


i would like to have the option that every time i choose an option, the data in the table is changed accordingly.
Also, i will add more data to the 1st sheet, so the table must keep being updated...
is it possible via Pivot tables or via other way?


Thanks!!


Itay

 

[RAMU]

Can't get you. Can you post any sample pls ?

 

[Itaybill]

sure...how can i post an excel sample or even a screenshot?

 

[RAMU]

Use Excel Jeanie Html.