Posted to microsoft.public.excel.misc

external usenet poster

Posts: 80

help with sales report

hey all,

i have some data like so:

ga, aug, rep1, $10.00
ga, atl, rep2, $5.00
ga, aug, rep1, $7.50
ga, aug, rep3, $5.00

is there a way in excel to convert to report format like so:

ga
- aug
-- rep1 - $17.50
-- rep3 - $5.00
--- total - $22.50
- atl
-- rep2 - $5.00
--- total - $5.00

thanks,
rodchar

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sales tracking report	PSikes	Excel Worksheet Functions	5	November 12th 09 09:34 AM
Sales Report	Andri	Excel Worksheet Functions	7	September 15th 08 06:18 PM
Add Sales Goals to Sales Report in Pivot Table	Ronster	Excel Discussion (Misc queries)	1	October 13th 06 04:17 AM
Sales Report Grrrr	jshafer817	Excel Worksheet Functions	7	August 1st 05 04:44 AM
Formula help in a monthly sales report.	chevyman	Excel Worksheet Functions	4	February 13th 05 03:05 PM

All times are GMT +1. The time now is 04:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us