I have a table with the following fields:

GroupName
Market
Sales

I'm trying to generate a Report that looks like this:


Code:

Market Quotes Purchases QuotesClosed%
Las Vegas 50 5 10%
Miami 100 20 20%
NY 500 200 40%

The Pivot Table I have generates the number of Quotes by a count of
GroupNames. Purchases is generated by a count of Sales. I can get that to
show up how I want it to but haven't been able to figure out how to calculate
the QuotesClosed%.

To generate the PivotTable I have Market dragged to the Row Labels box,
CountOfSales and CountOf. I have Values in ColumnLabels box. My first thought
was a calculated field with CountA(Sales)/CountA(GroupName) but that isn't
working.

Any suggestions on how to create the Closed% field in the PivotTable?

Thanks,

JG