ExcelKid_10
Board Regular
- Joined
- Mar 17, 2004
- Messages
- 87
Hi all-
I'm trying to create a flexible summary of the following data:
What I'd like to be able to do is allow the user to select a market name(s) and be able to calculate a price per unit (by month and type code) for the combined markets. For example, if a user selected North Dakota and then Wisconsin the resulting summary would add up the report quantity and dollar amounts and then calculate a price per unit for the combined market by each month. I've tried a pivot however I have been unable to get a grouping by market name. Does anybody have any thoughts on a good way to go about this? Perhaps a VBA route is more appropriate. Thanks for any replies!
I'm trying to create a flexible summary of the following data:
What I'd like to be able to do is allow the user to select a market name(s) and be able to calculate a price per unit (by month and type code) for the combined markets. For example, if a user selected North Dakota and then Wisconsin the resulting summary would add up the report quantity and dollar amounts and then calculate a price per unit for the combined market by each month. I've tried a pivot however I have been unable to get a grouping by market name. Does anybody have any thoughts on a good way to go about this? Perhaps a VBA route is more appropriate. Thanks for any replies!