Paul has attended:
Excel Advanced course
Pivot tables - calculated extra columns
hi
if I have a pivot table with the max and min of a data set, how do I add a column showing the variance (range) between the two - so in your training example, the gap between the highest and lowest salaries in a given country or region
thanks
RE: Pivot tables - calculated extra columns
Hi Paul,
Thank you for the forum question.
If you have the Max and Min values in your source table you can add a calculated column with the calculation =Max-Min.
If you in the PivotTable turn a field to return Max or Min, it is not possible to get what you want.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
