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