sort in pivot table
Couple of questions please
1) Is it possible to sort a row field ( Ascending / descending) by another field which is not part of the pivot table? 2) For row subtotals, is it possible to change the headings for sub total ? for eg. the pivot table just adds " sum" after the field . is it possible to have just " total " and nothing else. 3) is there a way to increase the number of row / column fields in Excel 2000. current I have 7 fields and its not allowing me to add additional. Any help appreciated |
All times are GMT +1. The time now is 11:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com