Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cindyliu77
-
Pivot Table Formating
YTD Actual Sum Total The pivot table which I have created contains 2 rows, 0 columns, and 1 set of data values. The YTD Actuls are in the data pivot table layout. Currently, when the pivot table is created, the 2 pivot table designated rows are lined up in the same excel row, and the...- cindyliu77
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Pivot table sort
Hi, I am trying to do a sort of values in descending order. Every time I highlight the pivot table and try to sort the Total actuals (amount), it would not allow me to do it. When I refresh, it automatically sorts it out for me by the name list, in alphabetical order! Thanks!- cindyliu77
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Copy Subtotals to a another sheet without copying details
Hi, Would you know how to copy the subtotal amounts, without copying the details associated with it to another worksheet? Everytime I highlight the sells and copy, it copies EVERYTHING, when all I want is to copy the subtotals. Thanks!!! Cindy- cindyliu77
- Thread
- Replies: 3
- Forum: Microsoft: Office
