+ Reply to Thread
Results 1 to 3 of 3

Need to get monthly sales from the data separately

  1. #1
    Registered User
    Join Date
    04-22-2016
    Location
    india
    MS-Off Ver
    2003 and 2010
    Posts
    2

    Need to get monthly sales from the data separately

    Dear Members, i Need to get solution of the problem. i have nearabout 50 sales persons and each month i need to calculate the sales of the men manually. More than 4 years of data is in excel file, and i need to get total sales of each individual person monthwise. As i tried this through pivot table, but it gives me the total sales of all months. is there any solution in which i get rid of this and get easily sales of the current month or any specific month
    Hope to get any solution
    Regards

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Need to get monthly sales from the data separately

    Pivot Tables should contain some form of filter to isolate a specific month.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    04-23-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Need to get monthly sales from the data separately

    Once you have the data in a pivot table right click on a date , select the option to Group and select Months, this will sort everything for you, you can add the dates to the Pivot Filter if you want to look at only specific months

+ 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. How to calculate the monthly sales based on the Data given ?
    By yjohari in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-09-2014, 07:10 PM
  2. [SOLVED] How can I add monthly sales data? Using formula?
    By matt323 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-29-2013, 07:42 PM
  3. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  4. Replies: 2
    Last Post: 10-17-2013, 11:52 AM
  5. Replies: 7
    Last Post: 07-23-2013, 07:56 AM
  6. Replies: 4
    Last Post: 03-27-2013, 05:56 PM
  7. Replies: 2
    Last Post: 06-19-2012, 10:19 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