recycleaus
asked on
Max & Min in PivotTable
I have a pivottable in that attached workbook which I would like to show the max value in one column and min value in another column for each 'Rego' (it will make more sense when you see the pivottable) from the 'Odo' column in the data table.
So for example for rego 1BF6CE min would be 350 and max 62472.
Thanks
Fuel-Summary.xlsx
So for example for rego 1BF6CE min would be 350 and max 62472.
Thanks
Fuel-Summary.xlsx
ASKER
Is it not possible to have this embedded in the pivottable?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect... thank you
Fuel-Summary.xlsx