PC Review


Reply
Thread Tools Rate Thread

CalculatedItem suppress running total

 
 
sugargenius
Guest
Posts: n/a
 
      23rd Feb 2007
I have a pivot table like this:

rows = date
columns = costset (ACWP, BCWP, BCWS, etc)
data = value

I've created calculated times for CPI and SPI
CPI = BCWP/ACWP, SPI = BCWP/BCWS

I want the cpi/spi for each period to be calculated off the cumulative-
to-date values, so for the value field I chose summarize by Sum and
Show data as Running Total in date.. This sums costsets up correctly
but then it also sums the calculateditems which I don't want

date ACWP BCWP BCWS CPI SPI
Oct-06 99.42 100.47 100.47 1.01 1.00
Nov-06 150.6 180.83 402.53 2.58 1.27
Dec-06 242.57 283.39 726.79 3.70 1.58

Look at Nov-06, it's cpi is 2.58. That's the previous period cpi plus
the current period cpi. If I turn off the Running Total, I just get
the current period cpi (which is accurate at least, but not what I
want)

date ACWP BCWP BCWS CPI SPI
Oct-06 99.42 100.47 100.47 1.01 1.00
Nov-06 51.18 80.36 302.06 1.57 0.27
Dec-06 91.97 102.56 324.26 1.12 0.32

Is there a way to enable running total for the value field but not for
the calculated item?

Thanks
Woody

 
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
Suppress total for first record of a group Goldar Microsoft Access Reports 1 11th Nov 2009 08:37 PM
Access 2007 Visual Basic Running Total and Percent of Total.... Nikolai Microsoft Access VBA Modules 0 13th Nov 2008 03:10 PM
RE: Duplicate Running Total Grand Total In Pivot Table Joel Microsoft Excel Misc 0 17th Aug 2008 03:13 AM
How Can I calculate a running total (prior total - expense)? =?Utf-8?B?VmljdG9y?= Microsoft Access Forms 0 5th Jul 2005 07:32 PM
suppress report page if total = 0 =?Utf-8?B?Y2F0aHk=?= Microsoft Access Reports 3 15th Mar 2004 03:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 PM.