Sum minimum values in a pivot table
Scenario:
State: Vendor: Value:
CA ACME $100
CA Test $95
FL Vendor1 $86
FL Vendor2 $110
Trying to create a pivot table that will show the minimum value by state
then sum the entire amount for all minimum values.
So the Pivot outcome would be:
CA $95
FL $86
Grand Total $181
Using the Summary functions in the Pivot but it keeps on bringing back the
entire total and not just the minimum values.
Thanks in advance
ak
|