Creating a Calculated Field From a Running Total Field


J

Joe

I currently have a Pivot Table that does a Running Total of Net Activity over
Time using Month as my Base Field.

Month Jan Feb Mar
Activity 5 4 2
Running Total 5 9 11

I need to be able to create and additional Calculated Field (Running Total -
Activity) using one of the Pivot Table Fields and the Running Total Field.

Month Jan Feb Mar
Activity 5 4 2
Running Total 5 9 11
New Calc Field 0 5 9

Once I create the Running Total it is not available as one of my field
choices in the Insert Calculated Field option. Please help. This comes up
often as one of our sales measures (Beginning of Month Activity) I currently
have to calculate this in the data warehouse however I would like to save
resources and effort by doing it here as I have the peices I need.

Thanks...
 
Ad

Advertisements

J

Joe

Thanks for the reply. I am actually using a running total based on month in
the pivot table. What I want to do is to be able to create a calculated
field using a pivot table field in combination with my running total field.

Joe
 

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