Results 1 to 2 of 2

Thread: Creating a Pivot table showing count by quarterly sales

  1. #1

    Creating a Pivot table showing count by quarterly sales



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello!

    Just some quick background.. I have a shared appointment sheet and a sales team that sets appointments inputs related appointment info into a spreadsheet created. based off of that we have several pivot tables showing information showing slaes made from those appointments which salesman has the most sales YTD, ect. I am looking to show a count of appointments made in each quarter shown in a pivot table. Is there an easy way to do this?
    Attached Files Attached Files

  2. #2
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    Did you ever get help with this? If not, a quick way might be to create an extra column which calculates which quarter you are in, using an IF statement or even a lookup table. Then the pivot table would be able to pull the info.

    But - you might want to consider setting up your data differently (only one tab with data, all months in a single column) and then pull all reports using pivot tables off the one table of data.

    Hope this helps!

Posting Permissions

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