Pivot Table - Excel

Posted on 2012-09-14
Last Modified: 2012-09-14
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?

Question by:Friggin_Lazy

    Author Comment

    I want for the result to show in the pivot table though...
    LVL 23

    Accepted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now