PC Review


Reply
Thread Tools Rate Thread

Summing a selection of lines in a pivot table

 
 
Zark3
Guest
Posts: n/a
 
      8th Jul 2008
Hi all,
Probably a totally newbie question on pivot tables but I can't seem to
find out how it works. Here's my problem:

I've got an Excel worksheet that (coming in from jet reports) contains
something like

#Asset 1 Description A1 Total A1 Mapping A1 = X1
#Asset 2 Description A2 Total A2 Mapping A2 = X1
#Asset 3 Description A3 Total A3 Mapping A3 = X2
#Liability 1 Description L1 Total L1 Mapping L1 = X3
#Liability 2 Description L2 Total L2 Mapping L2 = X4
#Liability 3 Description L3 Total L3 Mapping L3 = X4

This last field, mapping, is what's important for my pivot table; it's
the asset/liability id but in a different system. The first column is
unique in the excel file, the last column can be duplicated many-to-
one.

Currently I've got a pivot table set up like:
X1 Sum X1
X2 Sum X2
where X1 is the mapping of both A1 and A2 and X2 is the mapping of A3
for instance.

This works fine but I need to add subtotals like so:
X1 Sum X1
X2 Sum X2
[subtotal: X1+X2]
X3 Sum X3
X4 Sum X4
[subtotal: X3+X4]
Complete total

In other words I need to sum a couple of lines in a pivot table
according to a fixed schedule (grouping assets and then grouping those
subtotals to a total of assets etc.)

Thanks in advance for any help,
Chris
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table not summing japc90 Microsoft Excel Misc 2 16th Dec 2007 12:27 AM
Filter lines with Pivot table and non pivot table columns =?Utf-8?B?R3JvdmVy?= Microsoft Excel Charting 4 28th Sep 2007 04:16 AM
Filter lines with Pivot table and non Pivot table columns =?Utf-8?B?R3JvdmVy?= Microsoft Excel Misc 1 26th Sep 2007 01:48 AM
Filter lines containing pivot table and non pivot table data =?Utf-8?B?R3JvdmVy?= Microsoft Excel Worksheet Functions 0 24th Sep 2007 08:20 PM
Pivot Table - Summing s boak Microsoft Excel Worksheet Functions 1 18th Jul 2003 10:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:53 PM.