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 » Pivot tables
Pivot tables
Resolved · Low Priority · Version 2003
Wed 23 Sep 2009, 16:16Delegate Oksan said...
Oksan has attended:
Excel Advanced course
Pivot tables
how can i use the same variable in two different ways (such as having both the total sales and share of total sales on the same table)? Can this be shown in 2 columns in Excel 2003? Thanks!
Fri 25 Sep 2009, 16:46Trainer Andrew said...
RE: pivot tables
Hi Okshan
Thank you for your question. You can create calculated fields. Click in your pivot table and from the toolbar click PivotTable > Formulas > Calculated field. Give your new field a name then double click the name of the field you would like to copy. Excel will fill in the formula for your calculated field automatically. Click on OK and your field is added to the layout. The field is added vertically rather than horizonatally.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
Fri 2 Oct 2009: Automatically marked as resolved.
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:COUNT function vs COUNTA functionThe COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function. |
