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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTables - Calculations based on generated summary data
In pivot table u have two drop down buttons, select that button
go to insert | rows (columns option is been greyed out ) | name ( type what u want ) | add | ok On Sep 11, 12:26*am, John Gibson wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTables - Calculations based on generated summary data
I'm not sure I understand what drop down buttons you are reffering to. I
have the filters buttons in the column/row headings. I don't see any options to add rows from there. Where should I be looking for the dropdowns? Thanks, JG "muddan madhu" wrote: In pivot table u have two drop down buttons, select that button go to insert | rows (columns option is been greyed out ) | name ( type what u want ) | add | ok On Sep 11, 12:26 am, John Gibson wrote: 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 |
Reply |
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) |