PC Review


Reply
Thread Tools Rate Thread

(blank) fields should not have subtotals in pivot table

 
 
shripaldalal
Guest
Posts: n/a
 
      2nd Dec 2006
Hi,

I have made a pivot table (outline view) that works fine and given it
autoformat no 3 from autoformat options.

these are the fields:

ledger_ac
head_1
head_0
debit
credit

so it would come like this:

debit credit
head_0 subtotal subtotal
head_1 subtotal subtotal
ledger_ac value value

head_0 subtotal subtotal
head_1 subtotal subtotal
ledger_ac value value

now the question is that if head_1 is (blank) i can suppress the blank
by giving it a space, but i also wish to disable the subtotal for that
head_1, because if I hide head_1, then even the ledger_Ac
disappears.........

so basically what i need is that no subtotals a (blank) field.....or do
NOT DISPLAY the blank field all together but fields within that blank
fields should still be displayed........

Is this possible in the pivot table ?

Regards,
Shripal Dalal.

 
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
can i add subtotals to subtotals in a pivot table? JEM Microsoft Excel Misc 1 23rd Jan 2009 08:15 PM
Pivot Table Question: SubTotals for 2 of 4 Pivot Tables in same worksheet kansaskannan@gmail.com Microsoft Excel Programming 0 19th Dec 2006 05:13 PM
Pivot table help (blank) fields shripaldalal Microsoft Excel Discussion 3 1st Dec 2006 04:17 PM
Subtotals on for selected data fields in Pivot Table =?Utf-8?B?d2FjTlRO?= Microsoft Excel Programming 0 1st Nov 2006 07:51 PM
Pivot Table problem, blank fields aren't being added =?Utf-8?B?QW50?= Microsoft Excel Misc 3 8th Nov 2005 03:13 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:18 AM.