98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Pivot Table Format
excel training program - Pivot Table Format
Resolved · Low Priority · Version Standard
Wed 17 Jan 2007, 09:59
Edited on Mon 22 Jan 2007, 09:41Delegate Alex said...
Alex has attended:
Excel Advanced course
Pivot Table Format
I have created a pivot table as follows:
(Av Interpolated Libor) (Av Bid) (Bid Spread) (Av Offer) (Offer Spread)
F-Bill 1 Average Average Average Average Average
1/1/7 111 11 11 11 11
2/1/7 111 11 11 11 11
etc.
F-Bill 2 Average Average Average Average Average
1/1/7 112 12 12 12 12
2/1/7 112 12 12 12 12
etc.
I was wondering how I got rid of the average of all the data below line as when there is no data for one of the dates, the average automatically comes back as an error and there are gaps in the data quite frequently so this average line which appears in bold in the pivot table is not really useful.
Also want to get the bold line (which has lots of nones) removed and the top line which says "average of interpolated libor" "average of bid" etc not to say average but just "interpolated libor" and "Bid".
I can't include the whole sheet due to data sensitivity.
Thanks
Wed 17 Jan 2007, 10:00Delegate Alex said...
RE: Pivot Table Format
The formatting obviously didnt save on this post so can I just send the pivot table to an email address to make it easier to understand?
Wed 17 Jan 2007, 10:54
Edited on Wed 17 Jan 2007, 10:56Trainer Rich said...
Yes, send it in
Sure Alex,
Send it to forum AT stl-training.co.uk
and quote the following URL so we can jump back to the frum to answer your question.
https://www.stl-training.co.uk/post-791-pivot-table-format.html
Wed 17 Jan 2007, 12:02Trainer Rich said...
RE: Pivot Table Format
We've received your file now Alex. We will look into this, but it may take a day to get back to you. Thanks for your patience.
Rich
Mon 22 Jan 2007, 09:43Trainer Rich said...
RE: Pivot Table Format
Hi Alex,
We are still working on answering this question.
Rich
Mon 22 Jan 2007, 09:59Trainer Richard said...
RE: Pivot Table Format
REGARDING - "the top line which says "average of interpolated libor" "average of bid" etc not to say average but just "interpolated libor" and "Bid". "
simply click on the title and edit in the formula bar to whatever you want it to say
Mon 22 Jan 2007, 10:01Trainer Richard said...
RE: Pivot Table Format
REGARDING:
"Also want to get the bold line (which has lots of nones) removed "
As you are not able to modify this area, the work around is to simply highlight the cells you want removed, and colour the text the same as the background. White.
This will effectively hide the text, with out deleting it.
Mon 22 Jan 2007, 10:06Trainer Richard said...
RE: Pivot Table Format
Gaps in the data will cause errors to occur, especially with AVERAGE calcs.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |
