+ Reply to Thread
Results 1 to 4 of 4

Using Formulas Outside the Pivot Table

  1. #1
    Registered User
    Join Date
    09-05-2018
    Location
    Scottsdale AZ
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    69

    Using Formulas Outside the Pivot Table

    Hello,

    I want to project trending monthly sales using the MTD sales, divided by days worked, times working days. (MTD sales/days worked*working days). I have figure out the formulas using the pivot table cells but need to make it dynamic so the formula expands and contracts as the number of sales personal count changes.
    Last edited by darenferg; 01-27-2021 at 04:46 PM. Reason: adding excel sheet

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,421

    Re: Using Formulas Outside the Pivot Table

    We might be in a better position to help if we could see a sample of the pivot table and source data.
    Instructions for uploading an .xlsx file are given in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    09-05-2018
    Location
    Scottsdale AZ
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    69

    Re: Using Formulas Outside the Pivot Table

    I've added a copy of the excel sheet.

    Thanks
    Daren

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,421

    Re: Using Formulas Outside the Pivot Table

    No file attached to either post #1 or #3.
    If you attempted to upload using the paperclip icon, it doesn't work.

+ 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: 2
    Last Post: 09-13-2017, 01:55 AM
  2. Replies: 1
    Last Post: 03-26-2015, 10:33 AM
  3. Replies: 1
    Last Post: 08-12-2014, 12:00 PM
  4. Replies: 2
    Last Post: 05-08-2013, 04:56 PM
  5. Sort table with only formulas...and not pivot table
    By agweyre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2012, 09:19 PM
  6. Replies: 2
    Last Post: 05-19-2010, 05:14 AM
  7. pivot table to ingore formulas in data table
    By nicko54 in forum Excel General
    Replies: 0
    Last Post: 07-10-2008, 10:30 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