[mso] Pivot Tables

I am working in a pivot table.
 

The last two columns are formula's entered into the pivot table.  I
noticed that the totals carry down and keep the formula.  However, the
last two rows do not have the formula's.  I see they are sum's - but
there is data in there that makes me not understand why the formula does
not carry down.  How do I put formula's in the sum?  Makes it so I will
probably just put the raw data in there and then have to add colum's
with formula's - adds to the manual time.

 

Region

Sales District

ORDER_BY1

Sub Total

Class

DESCRIPTION

 UNITS_Budget

 UNITS_Actual

 Unit Var

 % Unit Budget

 

 

 

 

 

6-TANKS

104

21700

AST TANKS

           0.5 

            -   

-0.5

-100%

 

 

 

104 Total

 

           0.5 

            -   

-0.5

-100%

 

 

 

110

81700

COMM STOR TANKS

           3.8 

           1.0 

-2.8

-74%

 

 

 

 

82000

NILES TANKS

             -   

           2.0 

2

0%

 

 

 

110 Total

 

           3.8 

           3.0 

-0.8

-21%

 

 

6-TANKS Total

 

 

           4.3 

           3.0 

-1.3

-30%

 

Western States Sales, Inc. Sum

 

 

 

 

     4,717.4 

     4,029.0 

 

 

3- NW Sum

 

 

 

 

   12,638.3 

   11,410.0 

 

 

 

 

Thank You

Kathy



--------------------------------------------------------------------------------

The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. Any 
review, retransmission, dissemination or other use of, or taking of any action 
in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact 
the sender and delete the material from any computer.

--------------------------------------------------------------------------------

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: