+ Reply to Thread
Results 1 to 1 of 1

Calculation field in Pivot Table

  1. #1
    Registered User
    Join Date
    11-30-2010
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    1

    Calculation field in Pivot Table

    Tried to use search, but didn't find anything.
    Here is a problem:

    I try to add a calculation field to my pivot table that suppose to calculate:
    value for specific field divided by maximum value of another field.
    I try to make something like:

    = Value1 / MAX(Value2)

    The problem is: MAX(Value2) is calculated for specific field but not for the whole table as I need it. Is there any way to solve that?

    Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1