Hi there. I have a pivot that is set up as follows :
Branch - List of employees under Branch - sum of hours per employee. The pivot is filtered to show hours over 60.
There's a 10+ branches with 10+ employees under each branch.
Is it possible to create a column that only shows the max hours of each branch? Ie. for Manchester, show only 72.5 in Max column. For Barnsley, show only 72.0
Thanks.
Hi and thanks for sharing your example file.
However, it doesn't fully explain the request because the example numbers in the file don't match what you've written here. e.g. Manchester max is 500, not 72.5.
If you mean that the single largest sale for Manchester was 72.5 then you should be able to simply change the aggregation for the Sales to 'Max' instead of 'Sum' by right clicking > Field Settings > select max.
If that doesn't work, please provide a sample file containing your source data, PivotTable and desired result.
Mynda
Hi Mynda
thank you for replying so quickly. I'll attach a better example that hopefully explains it better.
I was trying to see if I could get a column that only shows the maximum value from the 'Sum of Hrs' and not the maximum value of an underlying entry.
Any advise would be greatly appreciated. Thanks.
