Alpha Video Training
Results 1 to 2 of 2

Thread: Sales Analysis

  1. #1
    Member
    Real Name
    Joseph Manners
    Join Date
    Jun 2006
    Posts
    16

    Default Sales Analysis

    I have a huge past invoice file. The key features are the invoice number, item number, qty ordered, cost, price, and item class.

    I am wanting a sales analysis report that would show jan, feb, mar, apr etc. sales, cost, gross profit, units by each of the 13 classes.

    Because I want to see everything even those customers who don't have sales in each class I thought I would need to create a separate Sales Analysis file. But if you do the math I would need 624 fields. Not to mention the time that it takes to update each field from the past invoice file.

    I am sure that there is something I can do with browses. But can anyone help me?

  2. #2
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,827

    Default Re: Sales Analysis

    If all 13 classes are defined in one field, then this is a classic case for CrossTab reports. Read up on that in the Help. You'd be able to get your Classes defined down the left, and your months across the top, with "analysis" (count, total, etc.) in each intersection cell. You may have to run more than one crosstab in order to get all of your measures.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

Similar Threads

  1. Can't get through to sales
    By Van Jones in forum Alpha Five Version 6
    Replies: 3
    Last Post: 09-22-2005, 03:48 PM
  2. Sales tax calculation for in state sales
    By Jim Gatton in forum Alpha Five Version 1
    Replies: 2
    Last Post: 01-04-2005, 11:11 AM
  3. Default sales tax
    By Ken Anklovitch in forum Alpha Five Version 6
    Replies: 6
    Last Post: 12-23-2004, 05:07 PM
  4. Systems Analysis Help with Problem
    By Graham Wickens in forum Alpha Five Version 4
    Replies: 9
    Last Post: 04-13-2003, 12:49 PM
  5. To someone in sales at A5
    By Tommy in forum Announcements
    Replies: 1
    Last Post: 08-20-2001, 05:29 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
  •