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!
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
