CalculatedItem suppress running total

S

sugargenius

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top