Thread: Cross tab table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
liem liem is offline
external usenet poster
 
Posts: 22
Default Cross tab table

I do not want to use Pivot function
I have a table of 5000 row with five column

Division District Salesman Factor result

If I want to recap the result by Saleman by District by division what is the
easy way to turn data to cross tabs .
How can i turn these data to Cross tab with the user be able pick a
Division-district it will show

Factor John Jeff Robin Diane Howard Scott ------------more salesman
sales R R G Y G G
profit G Y Y Y Y Y
GP% Y Y R R R R

--
thanks
liem