Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Pivottable

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training in uk - Pivottable

Resolved · Low Priority · Version Standard

Reply Fri 21 Sep 2007, 16:21Delegate Paul said...

Paul has attended:
Excel Advanced course

Pivottable

How do you use the % feature within pivot tables. Eg you have Sales, Budget, Variance and you want to know what the % Variance is. How is this possible?

For upcoming training course dates see: Pricing & availability

Reply Mon 1 Oct 2007, 16:15Trainer Amanda said...

RE: pivottable

Hi Paul

Thank you for your question.

If you double-click on the field you wish to display as a %, then click Options. This will extend the pivot table field dialogue box where you will have a show data as dropdown that you can choose from.

I hope this helps.
Amanda

Reply Mon 1 Oct 2007, 16:45Delegate Paul said...

RE: pivottable

Hmm...

I have the following on screen:

Actual - Target - B/W

I want a % B/W against Target.

When I get the field properties on screen, there is not an option to display as a % that I can understand in the above context. It refers to "Show Data as:", and the only one near logical is "% of". When you select this it then asks for the "Base Field", no problem, but then "Base Item"?????

Can you please be more speicific.

Many thanks in advance.
Paul

Reply Thu 4 Oct 2007, 12:51Trainer Amanda said...

RE: pivottable

Hi Paul

Sorry for the delay in replying, I've been out of the office for a few days.

Have you been able to find a solution this week or still having problems?

If you're still battling with the spreadsheet, it would be useful if you could tell me what field/s you have this information in within the pivot table - I'm assuming they're all in the data items area but of course could be wrong. Do you have any other information in other fields as well? Is the B/W figure created by a formula in the spreadsheet that the pivot table is created from?

Amanda

Excel articles

· Conditional Formatting: A Useful Feature Of Excel
· How Excel Can Help You See Into Your Business's Future
· Identifying Suitable Candidates For VBA For Excel Training
· Create Date Sensitive Colour Changing Cells In Excel
· Using The Excel Forms Toolbar To Spruce Up A Workbook

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips