Pivot Table layout

[Itaybill]

Hi All

I have a pivot table derived from another sheet, i wanted to know if there is any chance that the pivot will look like this (Job Width and Depth are columns on the DB sheet, the statistical functions are calculated):


Min Max Avg STDV
Job Width 1 453 66.2 133.9349231
Job Depth 3 678 145 269.9488167


it would be much more easier to manage it in a pivot, because then i will be able to filter the statistics by Territory / customer name etc... but if anyone has other suggestions i will be glad to hear.


Thanks!

Itay

 

[Itaybill]

Hi..

the table wasn't so clear...see below:


Min Max Avg STDV
Job Width 1 453 66.2 133.9349231
Job Depth 3 678 145 269.9488167


the idea is that the columns will be calculated (these functions exist on the pivot table)...

Itay