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
|