Pivot Table - Excel

Hello Everyone

I have a pivot table with data..

What i'm trying to find out.. is if there is a better way to approach my case:

I have the following columns:
List Count

Each name has a number of List counts.

I want to take the number they provide and divided by a number that is not on the data itself.  Is this possible?

Who is Participating?
You can add a calculated field...

select the table, go to Pivot Table Options tab, then Formulas >> Calculated Field

Enter a name to give the field.

Then in formula field enter:


where your_field is the field name from Fields that applies...

click Ok and now it should be a new available field to add to your PT
Friggin_LazyAuthor Commented:
I want for the result to show in the pivot table though...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.