View Single Post
  #2   Report Post  
Random Poster
 
Posts: n/a
Default Pivot Table Lay Out

wrote in news:1129819163.221301.52100
@z14g2000cwz.googlegroups.com:

Does anyone know if it is possible to chnage the layout of the "Data"
section of a pivot table in excel? In Access, when you run a pivot
form, you can have multiple data points shown side-by-side (i.e. Count
& Sum). In excel, it stackes these on top of each other.




It can be done. Actually, I wish it was the default position. After you
create the table, drag the "Data" label to the right, towards the column
field region. Watch the mouse icon, it should change when you get to the
right spot.


-RP