• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

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:
Names
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?

Thanks
0
Friggin_Lazy
Asked:
Friggin_Lazy
1 Solution
 
Friggin_LazyAuthor Commented:
I want for the result to show in the pivot table though...
0
 
NBVCCommented:
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:

=your_field/3

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
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now