If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Logical pivot table
Is there anyway to create a logical field and a pivot table for ex: colmun d is going to be a logical T. F. column E is going to be figures which is going to be sum for the pivot table but only the ones that agree eith column D logical
|
#2
|
|||
|
|||
Logical pivot table
dk,
When you create your pivot table, drag the column D header button to the row field, and column E to the data field. Then after the table is created, deselect either the TRUE or the FALSE as appropriate, and your pivot table will update HTH, Bernie MS Excel MVP "dk" wrote in message ... Is there anyway to create a logical field and a pivot table for ex: colmun d is going to be a logical T. F. column E is going to be figures which is going to be sum for the pivot table but only the ones that agree eith column D logical |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Export Pivot Table to Excel Sheet | Suntisuk | Using Forms | 0 | May 28th, 2004 08:56 PM |
(blank) displayed in pivot table | Keith | Worksheet Functions | 1 | February 28th, 2004 02:53 AM |
Probs with creating multiple pivot charts from pivot table | Retreatgal | Charts and Charting | 2 | January 28th, 2004 02:51 AM |
Pivot Table Too Many Rows Or Colums | Joe | Worksheet Functions | 0 | October 9th, 2003 05:17 PM |