Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTables - Calculations based on generated summary data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating a dynamic monthly summary sheet based on weekly data sh | Excel Discussion (Misc queries) | |||
How to create an executive summary of a text-based data list? | Excel Discussion (Misc queries) | |||
How to create an executive summary of a text-based data list? | Excel Discussion (Misc queries) | |||
Create a summary list without using PivotTables? | Excel Worksheet Functions | |||
Calculations using totals generated in Pivot Tables | Excel Discussion (Misc queries) |