+ Reply to Thread
Results 1 to 7 of 7

Pivot table with Sales and targets

  1. 04-19-2018, 05:01 AM #1
    bryanmcguire
    bryanmcguire is offline
    Registered User
    Join Date
    03-31-2015
    Location
    London
    MS-Off Ver
    2012
    Posts
    3

    Pivot table with Sales and targets

    Hi,

    I'm looking to create a pivot table with Sales and Targets across a 7 day time period. I would like the sales and target values to be in rows rather than columns. Is this possible? I have attached screen shot of pivot.

    thank you in advance...
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 04-19-2018, 05:48 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table with Sales and targets

    It is probably possible but hard to say from a screenshot. Can you post a sample of the data you have- as a workbook, not a picture?

    Also, can you amend your version information as Excel 2012 doesn't exist.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 04-19-2018, 06:06 AM #3
    bryanmcguire
    bryanmcguire is offline
    Registered User
    Join Date
    03-31-2015
    Location
    London
    MS-Off Ver
    2012
    Posts
    3

    Re: Pivot table with Sales and targets

    Hi, thanks for prompt response. I have uploaded excel workbook too.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-19-2018, 06:38 AM #4
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table with Sales and targets

    Is that the raw data for the pivot table?
    Reply With QuoteRegister To Reply
  5. 04-19-2018, 07:49 AM #5
    bryanmcguire
    bryanmcguire is offline
    Registered User
    Join Date
    03-31-2015
    Location
    London
    MS-Off Ver
    2012
    Posts
    3

    Re: Pivot table with Sales and targets

    Hi, Sorry, I have attached source data now.

    thanks again
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-19-2018, 09:03 AM #6
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot table with Sales and targets

    Not exactly the layout like in your screen but probably legibly.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 04-19-2018, 10:22 AM #7
    jg7793
    jg7793 is offline
    Registered User
    Join Date
    04-19-2018
    Location
    New York
    MS-Off Ver
    2007
    Posts
    4

    Re: Pivot table with Sales and targets

    Quote Originally Posted by stasinek View Post
    Not exactly the layout like in your screen but probably legibly.
    Thanks alot
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average sales per week per sales representative in pivot table
    By R12345 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-15-2016, 07:16 AM
  2. Help, Looking for a Formula for sales targets
    By Wattiboi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2015, 11:29 PM
  3. how can I 'reverse engineer' an annual sales budget to give me monthly growth targets?
    By Polite in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2013, 07:17 PM
  4. Sales daily sales data to be aggregated into monthly data (not using pivot table)
    By AlQadr in forum Excel General
    Replies: 4
    Last Post: 03-27-2013, 05:56 PM
  5. Setting sales targets
    By Garbzuk in forum Excel General
    Replies: 0
    Last Post: 10-16-2011, 04:08 PM
  6. Project milestones - how many targets met per quarter? Pivot table? (With example)
    By daves007221 in forum Excel General
    Replies: 3
    Last Post: 04-12-2011, 11:41 AM
  7. Sales spreadsheet - help with converting figures to % based on targets
    By tallonarcus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2011, 07:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1