excel training program - pivot table format

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Pivot Table Format

excel training program - Pivot Table Format

resolvedResolved · Low Priority · Version Standard

Edited on Mon 22 Jan 2007, 09:41

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

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?

Edited on Wed 17 Jan 2007, 10:56

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

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

RE: Pivot Table Format

Hi Alex,

We are still working on answering this question.

Rich

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

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.

RE: Pivot Table Format

Gaps in the data will cause errors to occur, especially with AVERAGE calcs.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips


Server loaded in 0.13 secs.