+ Reply to Thread
Results 1 to 2 of 2

Percent Rank Formula - Can we add the formula to Pivot Calculate field - Help Needed Pls!!

  1. #1
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Bangalore
    MS-Off Ver
    MS 365
    Posts
    150

    Percent Rank Formula - Can we add the formula to Pivot Calculate field - Help Needed Pls!!

    Hi All,

    Firstly, Happy New Year 2016 to Every One!!

    I would like to understand, if we can add Percent Rank formula to calculate Quintile based performance of an advisor in Pivot Calculated Field.

    I have enclosed my working file, where I have calculated Quintile for the respective metrics as Quintile Based Performance - Overall Site Performance, Quintile Based Performance - TL Wise Performance, Quintile Based Performance - Span Wise Performance, Quintile Based Performance - Queue Wise Performance, Quintile Based Performance - Tenurity Wise Performance. Formulas you can find in the attached document.

    Can we calculate/use these formula in Pivot Calculate field ? Please let me know if this is possible.

    I would appreciate if anyone could help on this please.

    Regards,
    Yadavagiri
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Bangalore
    MS-Off Ver
    MS 365
    Posts
    150

    Re: Percent Rank Formula - Can we add the formula to Pivot Calculate field - Help Needed P

    any help please

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-01-2016, 05:06 PM
  2. Replies: 2
    Last Post: 05-24-2012, 05:49 AM
  3. Replies: 3
    Last Post: 03-03-2012, 12:16 PM
  4. use a formula to calculate percent complete
    By SCL in forum Excel General
    Replies: 1
    Last Post: 08-01-2011, 01:30 PM
  5. Replies: 1
    Last Post: 11-23-2007, 03:11 AM
  6. Percent and Rank formula in one cell
    By T.R. in forum Excel General
    Replies: 2
    Last Post: 03-10-2005, 01:06 PM
  7. Need Formula or Function to calculate Margin (reverse of Percent a
    By Ken in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2005, 06:06 AM

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