Posted to microsoft.public.excel.misc

external usenet poster

Posts: 119

Aggregate tables

I have a table like below where I would like to aggregate,

Account Cat1 Cat2 Cat3 Cat4 Cat5 Cat6 Cat7 Amount
1100 REG
100.00
1120 FMA
200.00
1120 FIS
400.00
1120 FMA
600.00

The problem with using the pivot table is that when the accounts are the
same it does not repeat the accounts. Is there another way of aggregating
these rows.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Aggregate query	Hilton	Excel Discussion (Misc queries)	2	June 27th 07 09:20 AM
how do I aggregate dates	Johnopp	Excel Discussion (Misc queries)	5	March 5th 06 10:26 PM
Aggregate Data from a column in a cell	Enron	Excel Worksheet Functions	0	February 20th 06 04:36 PM
aggregate calculations	[email protected]	Excel Discussion (Misc queries)	0	May 26th 05 04:32 PM
How to aggregate values in a database	Frank	Excel Worksheet Functions	0	March 16th 05 01:15 PM

All times are GMT +1. The time now is 11:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us